I would like to know how postgresql defines that a connection is
inactive. I have the same problem but in the future I couldn't restart
my server every day.
Any explanation ?
Ezequias
2007/2/26, Goran Rakic [EMAIL PROTECTED]:
I have installed POSTGRESQL 8.2 on W2K3 32bit , 100 users connecting
Ezequias Rodrigues da Rocha wrote:
I would like to know how postgresql defines that a connection is
inactive. I have the same problem but in the future I couldn't restart
my server every day.
I believe IDLE = not currently processing a query / sending data back to
client.
Any explanation ?
- Original Message -
From: Ezequias Rodrigues da Rocha [EMAIL PROTECTED]
To: Goran Rakic [EMAIL PROTECTED]
Cc: pgsql-admin@postgresql.org
Sent: Wednesday, February 28, 2007 11:01 AM
Subject: [Bulk] Re: [ADMIN] Disconnecting non active (IDLE ) users
I would like to know how
"They took us away from our homelandAnd we are slaving down here in BabylonThey are waiting for an opportunityFor the Black Starliner which is to come "sisqo
MSN Messenger : appels gratuits de PC à PC partout dans le monde !
Hi,
We are using Postgres 8.1.0
Question No 1:
=
There are lots of system tables that are available in postgres. For
example pg_tables will have all the information about the tables that are
present in a given schema. pg_views will have all the information about the
views for
I want to find all the sequences. What is the system tables that have
the information about all the sequences?
psql -E -U user db
\ds
Capture the query that psql sends to the server.
Can't help with the dblink -- sorry.
-- Gary Chambers
// Nothing fancy and nothing Microsoft!
On Wed, 2007-02-28 at 12:19, Karthikeyan Sundaram wrote:
Hi,
We are using Postgres 8.1.0
Stop. Do not pass go, do not collect $200. Update your postgresql
installation now to 8.1.8. There were a lot of bugs fixed between 8.1.0
and 8.1.8.
After that...
Question No 1:
=
Hi,
I am using 8.2.1 on my dev server.
When I do a pg_dump, I am getting an error message.
pg_dump -U postgres podcast -t channel
pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn
How can I resolved this? What may be the problem?
Because of this, I am
Hi Joshua,
Thanks for your reply. No, I recently installed (fresh installation)
from scratch.
Regards
skarthi
From: Joshua D. Drake [EMAIL PROTECTED]
To: Karthikeyan Sundaram [EMAIL PROTECTED]
CC: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [ADMIN] pg_dump error
Karthikeyan Sundaram wrote:
Hi,
I am using 8.2.1 on my dev server.
When I do a pg_dump, I am getting an error message.
pg_dump -U postgres podcast -t channel
pg_dump: symbol lookup error: pg_dump: undefined symbol: PQescapeStringConn
How can I resolved this? What may be
Karthikeyan Sundaram wrote:
Hi,
I have to dump only 10 tables out of 100 tables. In the pg_dump utility
given by postgres there is an option called -t followed by table name.
In that option, if I give more than 1 table, it's not accepting.
How can I get the dump in one stroke
Hi all,
I have a server (Ubuntu 6.10 to be exact) running PostgresQL 8.1.4.
On that server I have a user account, called ynui, and I also have a
postgres user called ynui, they have the same password. Now the
server's IP is 192.168.0.1
My main postgres conf has in it:
listen_addresses =
On Thu, 1 Mar 2007, Rob van der Linde wrote:
On that server I have a user account, called ynui, and I also have a
postgres user called ynui, they have the same password. Now the
server's IP is 192.168.0.1
My main postgres conf has in it:
listen_addresses = 'localhost,192.168.0.1'
my
Hi,
I have to dump only 10 tables out of 100 tables. In the pg_dump utility
given by postgres there is an option called -t followed by table name.
In that option, if I give more than 1 table, it's not accepting.
How can I get the dump in one stroke for all the 10 tables? Please
Yes, pgadmin3 uses .pgpass to store its connection info - so that's your
likely culprit.
On Thu, 1 Mar 2007, Rob van der Linde wrote:
I had a .pgpass file in the home directory of the client PC. It's
possible PgAdmin III or some other program created it.
--
Jeff Frost, Owner [EMAIL
16 matches
Mail list logo