Re: [GENERAL] PG dump and restore

2010-06-28 Thread Dennis C
That was it exactly as I just tested the entire process and it all worked fine again. For some reason, I inadvertently replaced the "-Fc" part with a "-c" somewhere along the way. Thanks again! On Fri, Jun 25, 2010 at 5:18 PM, Adrian Klaver wrote: > On Friday 25 June 2

Re: [GENERAL] PG dump and restore

2010-06-25 Thread Dennis C
OK well the gunzip seemed to "do the trick," but I don't recall before having to do anything other than run the pg_restore command. Anyway, thanks to everyone for all your help! On Fri, Jun 25, 2010 at 11:29 AM, Adrian Klaver wrote: > On 06/25/2010 09:04 AM, Dennis C w

Re: [GENERAL] PG dump and restore

2010-06-25 Thread Dennis C
M, Thom Brown wrote: > On 25 June 2010 16:28, Dennis C wrote: > > Greetings; > > As I've been doing for quite some time, backed up my database as > > such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5 > > Trading-Access > > But then when I t

[GENERAL] PG dump and restore

2010-06-25 Thread Dennis C
Greetings; As I've been doing for quite some time, backed up my database as such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5 Trading-Access But then when I tried restoring it my usual way as such: /opt/local/lib/postgresql84/bin/pg_restore -d Trading-Access ./Trading-Acce

Re: [GENERAL] pg_restore: [archiver] entry ID -825110830 out of range -- perhaps a corrupt TOC

2009-01-20 Thread Dennis C
xpect over the years! Thanks for all your great work with that too in the first place! On Tue, Jan 20, 2009 at 10:40 AM, Scott Marlowe wrote: > On Tue, Jan 20, 2009 at 11:15 AM, Dennis C wrote: > > Greetings; > > And thanks for your reply! I tried the following: > > less x

Re: [GENERAL] pg_restore: [archiver] entry ID -825110830 out of range -- perhaps a corrupt TOC

2009-01-20 Thread Dennis C
estore to? I am not sure, but maybe there are occuring some problems ... > > $ less test.toc | grep "^;" > [...] > ; Dumped from database version: 8.3.5 > ; Dumped by pg_dump version: 8.3.5 > [...] > > Cheers > > Andy > - -- > St.Pauli - Ha

[GENERAL] pg_restore: [archiver] entry ID -825110830 out of range -- perhaps a corrupt TOC

2009-01-19 Thread Dennis C
Greetings: I already did some searches on the "pg_restore: [archiver] entry ID -825110830 out of range -- perhaps a corrupt TOC" error and am still not sure why my database's not restoring after upgrading the FreeBSD and select ports such as PostGreSQL. I did see something from a long time ago ab