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
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
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
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
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
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.
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,
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