Wed Mar 1 05:39:52 PST 2006
- Previous message: [Slony1-general] Listen path generation and bug 1485
- Next message: [Slony1-general] Example of adding a table to an existing set ... ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> hello, i'm new in postgresql and slony, i'm traying to replicate one db
> from
> 10.0.0.1 to 10.0.0.2, first, when databases were in the public schema all
> works fine, but now i ordered the database in one new schema, inside of
> 'myschema' i moved the databases and all my function, the public schema
> still exist. Now i trying to replicate some tables from 'mydatabase' and i
> get the ' slon_connectdb: PQconnectdb("dbname= host=10.0.0.2
> portuser=postgres") failed - could not connect to server: Is the server
> running
> locally and accepting connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.0"?', the connection are ok, ip too. The
> same
> schema exist in both sides.
Well, it looks like something about connectivity configuration can't be
right.
The DSN, in particular, doesn't appear valid.
"dbname= host=10.0.0.2 portuser=postgres" isn't nearly valid.
It looks as though your STORE PATH was passed invalid database connection
information.
You can run STORE PATH again to replace the paths with valid connection
information; that is likely to help.
- Previous message: [Slony1-general] Listen path generation and bug 1485
- Next message: [Slony1-general] Example of adding a table to an existing set ... ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list