Re: [ADMIN] Maintenance_work_mem question

On Nov 7, 2007 2:34 PM, Mark Steben <[EMAIL PROTECTED]> wrote: > We are upgrading from postgres 7.4.5 to 8.2.4 in a couple weeks. I am > debating as to what > > I should set my maintenance_work_mem and shared_buffers parameters to. > > Here are some of our current resources > > Total memory on m

[ADMIN] Maintenance_work_mem question

We are upgrading from postgres 7.4.5 to 8.2.4 in a couple weeks. I am debating as to what I should set my maintenance_work_mem and shared_buffers parameters to. Here are some of our current resources Total memory on machine: 32GB Total disks - 5 Raid 10 (so five primary, five mirrored) To

[ADMIN] dump from /var/lib/postgresql to recovery

Hi, i've a database that work perfectly until yesterday, that when i try to access into database from every commands like: "psql -U postgres db_name" Postgresql gives me an error: "server closed the connection unexpectedly This probably means the server terminated abnormally before o

Re: [ADMIN] Source of pgpool2 manual

Thanks for the link. r On Tue, 6 Nov 2007, Devrim G?ND?Z wrote: Hi, On Thu, 2007-11-01 at 12:27 -0600, Reed Loefgren wrote: I have installed pgpool from ports on a FreeBSD-6_STABLE box and have hit a roadblock (pgpooladmin can see the two nodes but they're both shown as "down"). Pretty sur