Re: [ADMIN] Postgresql.conf getting corrupted

2009-08-31 Thread Tom Lane
"Jason K. Ergle" writes: > I am having a problem with postgreql.conf becoming corrupted. We are using > version 8.2.9 in embedded systems running Fedora Core 7. Basically, the > postgres server holds the data that our embedded systems need to run. They > are all using industrial solid state dis

Re: [ADMIN] Postgresql.conf getting corrupted

2009-08-31 Thread Alvaro Herrera
Jason K. Ergle wrote: > I am having a problem with postgreql.conf becoming corrupted. We are using > version 8.2.9 in embedded systems running Fedora Core 7. Basically, the > postgres server holds the data that our embedded systems need to run. They > are all using industrial solid state disk dr

[ADMIN] Postgresql.conf getting corrupted

2009-08-31 Thread Jason K. Ergle
I am having a problem with postgreql.conf becoming corrupted. We are using version 8.2.9 in embedded systems running Fedora Core 7. Basically, the postgres server holds the data that our embedded systems need to run. They are all using industrial solid state disk drives on the ext3 file system.

Re: [ADMIN] postgresql.conf

2006-01-09 Thread Tom Lane
"Sistemas C.M.P." <[EMAIL PROTECTED]> writes: > I had to change the file postgresql.conf (section FILE LOCATIONS -> = > data_directory)because I need to point to another location. > But when I reboot the system, it indicates fail (red color) on the = > startup of postgresql service. > But then, it

[ADMIN] postgresql.conf

2006-01-09 Thread Sistemas C.M.P.
I had to change the file postgresql.conf (section FILE LOCATIONS -> data_directory)because I need to point to another location. But when I reboot the system, it indicates fail (red color) on the startup of postgresql service. But then, it accept conections normaly and work fine with the data

[ADMIN] Postgresql.conf setting recommendations for 8.0.1

2005-04-01 Thread Pallav Kalva
Hi, We are migrating to a new server with more memory and also from postgres 7.4 to postgres 8.0.1 version. Here are my settings on the current 7.4 version: OS : RedHat 9 CPUS: 2 hyperthreaded Memory: 4gig shared_buffers: 65536 sort_mem: 16384 vacuum_mem: 32768 wal_buffers: 64 effective_cache_s

Re: [ADMIN] postgresql.conf file and logging questions

2004-03-29 Thread Lamar Owen
On Saturday 27 March 2004 08:32 pm, [EMAIL PROTECTED] wrote: > 1. Where should the postgresql.conf file be to be recognized by the > service on startup? currently, it is inside my $PGDATA directory but > all of its contents are commented out. It is a template. This is where the file should be l

Re: [ADMIN] postgresql.conf file and logging questions

2004-03-28 Thread Tom Lane
[EMAIL PROTECTED] writes: > 1. Where should the postgresql.conf file be to be recognized by the > service on startup? currently, it is inside my $PGDATA directory but > all of its contents are commented out. That's the correct file. Uncomment anything you want to change. > 2. I can't find a

[ADMIN] postgresql.conf file and logging questions

2004-03-27 Thread admin
Hello list, 1. Where should the postgresql.conf file be to be recognized by the service on startup? currently, it is inside my $PGDATA directory but all of its contents are commented out. 2. I can't find any log files for postgres. Inside my /var/log/ directory, there is an empty file call

[ADMIN] postgresql.conf and pg_ctl reload

2004-03-22 Thread Litao Wu
Hi all, postgresql.conf says: # This file is read on postmaster startup and when the postmaster # receives a SIGHUP. If you edit the file on a running system, you have # to SIGHUP the postmaster for the changes to take effect, or use # "pg_ctl reload". Does that mean I can just use "pg_ctl reloa

Re: [ADMIN] postgresql.conf.... virtualhost ???

2003-09-28 Thread Gaetano Mendola
Greg Patnude wrote: Running 7.3.4 on a FreeBSD 4.7 box. Been using postgreSQL for about 2 years now... I have been the pg-Administrator on a client's dedicated server where I ddidnt have control over installation / compilation of postgreSQL... I decided that I needed a development server of my own