Thu Jun 26 11:13:43 PDT 2008
- Previous message: [Slony1-general] Re: Slony1-general Digest, Vol 16, Issue 27
- Next message: [Slony1-general] Logshipping dump import failure
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I have not had a response to the error I received when trying to subscribe a third node to my set. So in the meantime, I'm investigating logshipping which is probably a better option for the replication needs of this third node anyway. I've read the logshipping notes a dozen times. http://www.slony.info/documentation/logshipping.html I used slony1_dump.sh on Node 2 (subscriber to set 1 from Node 1). It appeared to work fine. It quickly produced a SQL file that is about 11MB. On the third node, I am using this command to import the dump: psql -d my_db_name -a -f dump.txt The import is failing, and it appears it is choking on an array column. That is, I have a table with a column that has a data type of text[] -- which is an array. In the dump, this is represented as {a,b,c}. If I take the line that the import is choking on and remove that column, it works. Thoughts?
- Previous message: [Slony1-general] Re: Slony1-general Digest, Vol 16, Issue 27
- Next message: [Slony1-general] Logshipping dump import failure
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list