Re: [ADMIN] Problem: pg_hba.conf is automatically rewritten every day

2013-05-03 Thread Johnny Tan
Chef/Puppet? On Fri, May 3, 2013 at 10:28 AM, Ray Stell wrote: > > On May 3, 2013, at 9:45 AM, Nghia Truong wrote: > > Hi everyone, > Every day, the file pg_hba.conf in my server is rewritten and postgresql > received > a SIGHUP to reload configuration. > > > Sounds like some sysadmin scripted

Re: [ADMIN] postmaster is restarting

2013-04-29 Thread Johnny Tan
Chef or Puppet? On Mon, Apr 29, 2013 at 5:48 PM, Lou Picciano wrote: > You probably have a service with overarching control over PostgreSQL. > Gonna depend on how you installed PostgreSQL, which distro you've > installed, etc... > > > - Original Message - > From: Rodrigo Barboza > To: p

Re: [ADMIN] SSL question

2013-02-04 Thread Johnny Tan
On Feb 4, 2013 8:50 PM, "CS DBA" wrote: > > All; > > We have a client that is asking for a service as follows: > > - a virtual machine in our data center > - they want to upload files to the VM via sftp > - they want to connect to a local db server on the VM via SSL > > Here's my question; > Do I

Re: [ADMIN] changes to postgresql.conf

2012-09-24 Thread Johnny Tan
On Sep 24, 2012 9:20 AM, "Magnus Hagander" wrote: > > For shared_buffers, you need a stop/start. For the other three, a > reload is enough. Thank you.

[ADMIN] changes to postgresql.conf

2012-09-24 Thread Johnny Tan
I need to make changes to these settings in postgresql.conf: * effective_cache_size * shared_buffers * work_mem * maintenance_work_mem On a live, production server, can I simply do a "reload" and get those values in, or do I need to do a stop/start? -- Sent via pgsql-admin mailing list (pgsql-a