[ADMIN] user connection properties

Hello Gurus, From which internal tables/views I can get the user connection application/job name ? (pg_stat _activity has the client ip address only) Thank you Isabella- --- Isabella A. Ghiurea isabella.ghiu...@nrc-cnrc.gc.ca Can

Re: [ADMIN] user connection properties

Isabella Ghiurea wrote: > Hello Gurus, > From which internal tables/views I can get the user connection > application/job name ? (pg_stat _activity has the client ip address > only) I don't think that information is stored anywhere within Postgres. -- Alvaro Herrera

Re: [ADMIN] user connection properties

On Tue, Jul 14, 2009 at 4:05 PM, Isabella Ghiurea < isabella.ghiu...@nrc-cnrc.gc.ca> wrote: > Hello Gurus, > From which internal tables/views I can get the user connection > application/job name ? (pg_stat _activity has the client ip address only) Unlike Oracle, PG doesn't give you the

[ADMIN] ezSQL postgres connection string...

Hello, I've got a web site that broke when we experience some system problems. The site was built using ezSQL. I need to specify a port for the connection string. Does anyone know what the argument is called in ezSQL? Thanks, in advance. Carol -- Sent via pgsql-admin mailing list (pg

Re: [ADMIN] Hard link / rsync backup strategy successful

Kevin, Kevin Grittner wrote: As a follow-up to this: http://archives.postgresql.org/pgsql-admin/2009-03/msg00233.php I just read this post. What exactly does doing the hard link buy you here? Since it's just another inode pointer to the same file, I fail to see what the purpose of it is

Re: [ADMIN] Hard link / rsync backup strategy successful

I'm in agreement. That is a recipe for a failed recovery. If you must use some file system / volume trickery to get an initial backup then I would suggest looking into LVM or some similar volume manager. For beginners, take a look at the link below. http://tldp.org/HOWTO/LVM-HOWTO/snapshots_b

[ADMIN] Networking request

Hello- I am looking for a great postgreSQL DBA and we offer a 1K referral fee for a successful hire. Who do you know that might be a good fit for this? Thanks! Year Founded: 2006 # of employees: 22ish people Location: San Mateo, CA Current Co. revenue/funding: 25 million in funding, look

Re: [ADMIN] Setting Shared-Buffers

2G per process is plenty ...and useful if you have large data warehouse style queries which are long running (especially multiple of those) We do benefit from the Linux memory caching model regardless of what Postgres uses right ? On a machine which we upgraded from 4G to 16G on a 32 bit PAE k

[ADMIN] PostgreSQL/PAM problem

Sorry if this comes a t a repost, but I never saw my original post appear in the list and deither did I get any answers... == I am trying to set up PAM-auth for a small testing system but I am stuck with a strange problem. The system authenticates OK (both login and ssh can authenticate using

Re: [ADMIN] PostgreSQL/PAM problem

Thomas Kirchtag writes: > 2009-07-08 21:28:06 CEST LOG: 0: pam_authenticate failed: Permission > denied > 2009-07-08 21:28:06 CEST LOCATION: CheckPAMAuth, auth.c:1345 > This suggests some problems accessing some pam-related file but I cannot > imagine which one? Yeah, I'd guess the same.