[ADMIN] Vacuuming DVs with few/no updates?

2003-02-05 Thread Preston
that I want to make sure I'm not missing some other important functionality that it does... Cheers, -Preston de Guise. -- Oops. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Vacuuming DVs with few/no updates?

2003-02-05 Thread Preston
Quoting Tom Lane <[EMAIL PROTECTED]>: > Preston <[EMAIL PROTECTED]> writes: > > Just wondering about how useful the vacuumdb functionality is for a > > database > > that pretty much only ever gets inserts/selects. > > > I've got a database that is

Re: [ADMIN] Database backup

2003-02-12 Thread Preston
to make the script generic by database name but that's relatively easy. The script that calls this then does a bzip2 on the database backup. This is called as part of a Legato NetWorker savepnpc process, which then writes it off to tape as part of the filesystem backup... As I said, it&#x

[ADMIN] Want to tech review PostgreSQL backup chapter?

2006-07-13 Thread Curtis Preston
I’m the author of the O’Reilly book “Backup & Recovery,” due to be released in Q3 of this year.    Among other things, it has a chapter on backing up PostgreSQL.   I’m looking for a few PostgreSQL-knowledgeable folks to provide a technical review of this chapter.  Obviously I’d want yo

[ADMIN] pg_dumpall -> database import -> user problem.

2002-07-02 Thread Preston de Guise
--no-acl". Any thoughts on this would be appreciated. Apologies if this is answered in the archives - I did look though and couldn't find anything ;) Cheers, -Preston de Guise. -- 'There are no secrets. The networked market knows more than companies do about their own prod

[ADMIN] pg_dumpall -> database import -> user problem.

2002-07-02 Thread Preston de Guise
--no-acl". Any thoughts on this would be appreciated. Apologies if this is answered in the archives - I did look though and couldn't find anything ;) Cheers, -Preston de Guise. -- 'There are no secrets. The networked market knows more than companies do about their own prod

Re: [ADMIN] pg_dumpall -> database import -> user problem.

2002-07-06 Thread Preston de Guise
On Tue, 2002-07-02 at 23:43, Tom Lane wrote: > Preston de Guise <[EMAIL PROTECTED]> writes: > > The procedure that I'm trying is: > > > pg_dump production > production.dump > > dropdb development > > createdb development > > psql development