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 port= user=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.
in one i have slackware with postgresql 7.4.3(
10.0.0.2), in the other
side i have Debian with postgresql 7.4.8(
10.0.0.2) in both side the
slony version is 1.1.0h.
any idea?
thanks to all
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
