On Fri, Feb 24, 2012 at 10:28 AM, Chris Travers
<..hidden..> wrote:
I think at this point we should take this up on the pgsql-general list. If you are getting segfaults on the backup, I am not quite sure what is going on here. Our backup program is just a simple wrapper around pg_dump.
You can try this with:
pg_dump -F c -f test.bak my_db_name
try to restore and see if you get the same error. If you do we need to take that up with the Pg folks.
Best Wishes,
Chris Travers
.
.
pg_restore: [archiver (db)] Error from TOC entry 3662; 2606 32116 FK CONSTRAINT voucher_trans_id_fkey ledgersmb
pg_restore: [archiver (db)] could not execute query: ERROR: constraint "voucher_trans_id_fkey" for relation "voucher" already exists
Command was: ALTER TABLE ONLY voucher
ADD CONSTRAINT voucher_trans_id_fkey FOREIGN KEY (trans_id) REFERENCES transactions(id);
pg_restore: [archiver (db)] Error from TOC entry 3695; 2606 32580 FK CONSTRAINT yearend_trans_id_fkey ledgersmb
pg_restore: [archiver (db)] could not execute query: ERROR: constraint "yearend_trans_id_fkey" for relation "yearend" already exists
Command was: ALTER TABLE ONLY yearend
ADD CONSTRAINT yearend_trans_id_fkey FOREIGN KEY (trans_id) REFERENCES gl(id);
I logged into my new database successfully. I was brought to my preferences page where I needed to update my password before it expired. It appears that none of my users and customers though were restored. All my inventory though was there. Instead of creating my initial DB via
setup.pl, should I have instead created a blank DB using template0 or template1 and then used my backup to restore into it?
--
Best Regards,
Steven Marshall