Hi all,
I was not quite sure if this is the right forum for this question (if it
aint.oh well).
I have had a postgresql server up and running smoothly for 1.5 years now -
no problems at all..but:
I now need to be able to administer the server remotely, as well as allow
remote logins from a WAN.
Hi Klay,
On Sat, Dec 15, 2007 at 11:11:53AM +0200, Klay Martens wrote:
I was not quite sure if this is the right forum for this question (if it
aint.oh well).
I have had a postgresql server up and running smoothly for 1.5 years now -
no problems at all..but:
I now need to be able to
In article [EMAIL PROTECTED],
Klay Martens [EMAIL PROTECTED] writes:
I have had a postgresql server up and running smoothly for 1.5 years now -
no problems at all..but:
I now need to be able to administer the server remotely, as well as allow
remote logins from a WAN.
Did you set the
Hi..yes, I have set the listen_addresses to *...rather an obvious first
stop...As I said - I have no problems connecting locally, or on a LAN - no
sweat at all. Simply cannot get the connection to work from another network
over a WAN. I believe the problem stems from my not setting pg_hba.conf
On Sat, Dec 15, 2007 at 01:39:44PM +0200, Klay Martens wrote:
Hi..yes, I have set the listen_addresses to *...rather an obvious first
stop...As I said - I have no problems connecting locally, or on a LAN - no
sweat at all. Simply cannot get the connection to work from another network
over a
Hi people,
How can I export (dump) database more than 1 file?
I have great table and can't split.
Like Oracle, just set the parameter filesize and the
files name, and dump in several files.
Could I do it the same way in PG?
Thank you in advance.
Abra sua conta no Yahoo! Mail, o Ășnico
On Dec 15, 2007 11:42 AM, A.Burbello [EMAIL PROTECTED] wrote:
Hi people,
How can I export (dump) database more than 1 file?
I have great table and can't split.
Like Oracle, just set the parameter filesize and the
files name, and dump in several files.
You could pipe the output of pg_dump to
also make sure you started postgesql with -i option, so you can connect from
the lan
Julioc.
From: [EMAIL PROTECTED]
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_hba.conf is driving me nuts
Date: Sat, 15 Dec 2007 13:39:44 +0200
Hi..yes,
On Dec 13, 2007 4:39 PM, Tena Sakai [EMAIL PROTECTED] wrote:
Hi Scott,
Thanks for the sql statement with pg_stat_activity.
You can set the value for statement_timeout and any statement
that takes over that amount of time will generate a timeout and you
then log it in the logs.
I