Re: [ADMIN] Find how much memory is postgres using

Nik Tek wrote: > Could someone tell m how to measure postgres memory usage. > Is there a pg_* view to measure? No, you have to use operating system tools, like "ps" on UNIX. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscripti

Re: [ADMIN] risks of backup using filesystem snapshot/dump ?

Jim Mercer wrote: > i'm running pgsql 9.1.3 (soon to be upgraded to 9.2.x) on FreeBSD 8-STABLE. > > i've got a db of some 550GB that i want to backup on a daily basis, as we > have had some nasty hardware/power/other issues of late. > > with dump on FreeBSD, you can specify -L, which does a files

[ADMIN] how to terminate hang up sender process

Hi all, I'm using PostgreSQL 9.1.7's replication function for my HA project and getting trouble when terminate the hangup sender process. My cluster configuration: Node1(MASTER) Node2(STANDBY) Execution sequence: --- step 1. execute pg_basebackup on Node2 step 2. While Node2's pg_basebackup is

[ADMIN] High growth company seeks postgres DBA

We're looking to hire a DBA with postgres experience. If you or anyone you know who might be interested in a full time permanent position (not consulting), please contact me as soon as possible for more information. This is an urgent need. Best, Sharda Shiffrin sharda.shiff...@asurion.com

Re: [ADMIN] High growth company seeks postgres DBA

You might have better luck in the postgresql list specifically for job postings. http://www.postgresql.org/list/pgsql-jobs/ On Mon, Apr 8, 2013 at 3:26 PM, Shiffrin, Sharda < sharda.shiff...@asurion.com> wrote: > We’re looking to hire a DBA with postgres experience. If you or anyone > you know