Re: [ADMIN] Upgrade from 8.1.4 to 8.1.9

2007-06-24 Thread Jeff Frost
On Sun, 24 Jun 2007, Campbell, Lance wrote: In order to upgrade from 8.1.4 to 8.1.9 I get the impression from the documentation I should do the following: 1) stop my database 2) back it up (just for safety purposes) 3) install the new version overtop of the old one (I would

[ADMIN] Upgrade from 8.1.4 to 8.1.9

2007-06-24 Thread Campbell, Lance
In order to upgrade from 8.1.4 to 8.1.9 I get the impression from the documentation I should do the following: 1) stop my database 2) back it up (just for safety purposes) 3) install the new version overtop of the old one (I would actually rename the install directory of 8.1

Re: [ADMIN] initdb problem

2007-06-24 Thread Joe Barwell
Tom Lane <[EMAIL PROTECTED]> wrote: Joe Barwell <[EMAIL PROTECTED]> writes: > I get the same result trying to initdb after rebooting, the > end of which is: > /Library/PostgreSQL8/data/base/1 ... FATAL: could not > create shared memory segment: Cannot allocate memory > DETAIL: Failed system call

Re: [ADMIN] initdb problem

2007-06-24 Thread Joe Barwell
John DeSoi <[EMAIL PROTECTED]> wrote: >This has got to be the longest thread ever to get PostgreSQL running on the Mac -- but I'm glad you have not given up :). Hi John, Partly it's because I don't have much time to spend investigating this, partly it's a very positive reflection of the great wi

Re: [ADMIN] Load DB - Conversion from 8.1.4 to 8.2.4

2007-06-24 Thread Tommy Gildseth
Campbell, Lance wrote: I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do the following command in order to load the new database after install? pg_dump -h /host1/ –p 1234 /dbname/ | psql -h /host1 –p 56789/ /dbname/// Remember that port 1234 is PostgreSQL 8.1.4 and port 567

[ADMIN] Load DB - Conversion from 8.1.4 to 8.2.4

2007-06-24 Thread Campbell, Lance
I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do the following command in order to load the new database after install? pg_dump -h host1 -p 1234 dbname | psql -h host1 -p 56789 dbname Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is PostgreSQL 8.2.4. Than