Re: [ADMIN] Stupid mistake: Forgot to dump when upgrading. (7.3 -> 7.4.2)

2004-06-23 Thread Kevin Schroeder
Try re-installing PostgreSQL, dumping it, then re-installing the new version. Kevin - Original Message - From: "Jón Ragnarsson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 23, 2004 12:29 PM Subject: [ADMIN] Stupid mistake: Forgot to dump when upgrading. (7.3 -> 7.4.

Re: [ADMIN] Shared memory error using initdb on Solaris 8

2004-05-21 Thread Kevin Schroeder
Searching Google brought up this page. http://www.postgresql.org/docs/current/interactive/kernel-resources.html - Original Message - From: "Jim Seymour" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 21, 2004 1:14 PM Subject: Re: [ADMIN] Shared memory error using initdb

Re: [ADMIN] Shared memory error using initdb on Solaris 8

2004-05-21 Thread Kevin Schroeder
There we go. For reference, what page did you get that info and what did you search for to get it? Kevin - Original Message - From: "Jim Seymour" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 21, 2004 10:57 AM Subject: Re: [ADMIN] Shared memory error using initdb on Sola

[ADMIN] Shared memory error using initdb on Solaris 8

2004-05-21 Thread Kevin Schroeder
Hello, I'm trying to install PostgreSQL 7.4.2 on a brand new SunFire 120 with 2GB of RAM but when I run initdb -D /usr/local/pgsql/data I get the following error: creating directory /usr/local/pgsql/data... ok creating directory /usr/local/pgsql/data/base... ok creating directory /usr/local/pg

Re: [ADMIN] initdb error

2004-05-05 Thread Kevin Schroeder
That would seem to be the problem. Thanks. Kevin - Original Message - From: "Jim Seymour" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 04, 2004 6:26 PM Subject: Re: [ADMIN] initdb error > "Kevin Schroeder" <[EMAIL PROTECTED]>

[ADMIN] initdb error

2004-05-04 Thread Kevin Schroeder
Hello, I'm trying to install PostgreSQL on Solaris 9. Everything's compiled properly but when I run initdb I get the following error: Sun Microsystems Inc. SunOS 5.9 Generic May 2002 The files belonging to this database system will be owned by user "pgsql". This user must also own the

[ADMIN] Transaction log file screwed up

2004-04-22 Thread Kevin Schroeder
Hello, A client database crashed last night and I think I found the solution to the problem at http://www.varlena.com/varlena/GeneralBits/45.php "Database Recovery Procedures ". The solution was to append the file with enough zeros to get the file size correct. The solution was to run dd bs=