I’m working on a project where we are using pg_dump to get the data out of one database and then using psql to load it into another. The second database is the master db in a Slony replication cluster.
No matter what options I specify in pg_dump the changes are not being replicated.
I’ve use a standard dump which uses
--inserts dump which uses
INSERT INTO and a
--insert-columns dump which adds column names to the
INSERT INTO statements.
If I edit the data in pgAdmin III using the view option for the table, that change is replicated just fine.
What is the difference between editing the data that way in pgAdmin III and using psql to load a dump file?