RE: [ADMIN] Backing up postgresql databases

2001-03-17 Thread John W Cunningham
Peter, >From what I understand (and I'm still fairly new to Postgres) you won't get a perfect copy while Postmaster is running, but there is a way to backup the entire database while it's running: pg_dumpall. pg_dumpall by default is in the /usr/bin directory, and they usage is simple: /usr/bin/

RE: [ADMIN] Crash

2001-03-14 Thread John W Cunningham
I ran the test - can anyone tell me what these results mean and how I can fix it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Wednesday, March 14, 2001 12:02 PM To: John W Cunningham Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Crash

RE: [ADMIN] Crash

2001-03-14 Thread John W Cunningham
I can't even find the source file, I really need to see what these guys used when installing. -JOhn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Wednesday, March 14, 2001 12:02 PM To: John W Cunningham Cc: [EMAIL PROTECTED] Subjec

RE: [ADMIN] Crash

2001-03-14 Thread John W Cunningham
The server was installed by my ISP for me (when I install it's from a GreatBridge rpm). How do I run the regression tests? -John -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 9:59 AM To: John W Cunningham Cc: [EMAIL PROTECTED] Subjec

[ADMIN] Crash

2001-03-14 Thread John W Cunningham
Hello All, I'm pretty new to Postgres, but have managed to build a substantial site on it. I built the entire thing locally on some dev servers, and then put it online. The production DB server is a superb machine (twin PIII Ghz, 2 gigs RAM) so it should be able to handle anything my dev server