[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: How to restore backup
- Subject: Re: How to restore backup
- From: Steven Marshall <..hidden..>
- Date: Fri, 24 Feb 2012 11:04:13 -0200
Doing as you suggested it seems to partially work outside of Ledgersmb.
On Fri, Feb 24, 2012 at 10:28 AM, Chris Travers <..hidden..>
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.
..hidden..:~> pg_dump -F c -f test.bak StallusBoutique_Test
..hidden..:~> pg_restore -d StallusBoutique test.bak
< I get a bunch of errors similar to the sample errors below which I assume is expected since I created the DB via setup.pl>
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?
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
Ledger-smb-users mailing list