[ADMIN] Setting up data on two drives newb version.

2005-02-12 Thread Joel Fradkin
I just wanted to thank everyone who jumped in to help me. Hopefully I have it set up ok. Postgres install using more then one raid array for drives. Install Postgres (I did not let the OS install it as I was wanting to use 8 and Fedora Core 3 was shipping with 7.4) After I installed Fedora, I wen

[ADMIN] Setting up data on two drives newb version. left off a little info on memory if you change the shared buffers.

2005-02-12 Thread Joel Fradkin
This was also in the Desknow web page. changing these parameters will probably cause postgres to not start. su - postgres pg_ctl -D /var/lib/pgsql/data start ( I actualy left the path off ) in the message it says you need to increase SHMMAX to a certain number. To do this you must be root echo /

Re: [ADMIN] Setting up data on two drives newb version. left

2005-02-12 Thread John Jensen
Bruce Momjian has an other interesting manual on hardware performance tuning: http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html It covers a lot of the same ground plus some other goodies. /John >>> "Joel Fradkin" <[EMAIL PROTECTED]> 12-02-2005 16:22:28 >>> This was also in t

Re: [ADMIN] Trouble Escaping Quotes

2005-02-12 Thread Haron, Charles
I upgraded to 7.3.9, and that fixed the problem. Thanks, Chuck > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 26, 2005 10:12 AM > To: Haron, Charles > Cc: pgsql-admin@postgresql.org; Richard Poole > Subject: Re: [ADMIN] Trouble Escaping Quote