Alvaro Herrera wrote:
> There is a sleep time between check for new files
Even after a successful copy? Why would you want that?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
John Lister wrote:
> Hi, I've set up a warm standby box with postgresql 8.3.8 and
> pg_standby. Everything seems to be ok except and the wal files are
> being copied across and being processed during the recovery as you'd
> expect but I have one question. The recovery seems to be processing
> the f
You should use -m fast option to cleanly and gracefully shutdown the
database. Immediate option is rarely used and typically when you cannot
shutdown your database gracefully with -m fast option. So normal
situation, yes, go with -m fast.
Regards,
Husam
-Original Message-
From: pgs
Do people use "gp_ctl stop -m i" in production? I've had some difficulty
with the apps admin getting all the clients shut during maintenance
windows. I'm wondering what I should add to may init.d script, fast
or immediate. The 8.3 doc says:
'"Fast" mode does not wait for clients to disconnect.
On Fri, Nov 13, 2009 at 12:38 PM, Tom Lane wrote:
>
> Perhaps postgres isn't a member of myadmin?
>
>
That's what I was missing -- thanks Tom.
Joe
Joe Miller writes:
> If I set this:
> unix_socket_group = 'myadmin'
> unix_socket_permissions = 0777
> ...connection is refused for all accounts.
Have you checked the postmaster's log to see if it's reporting any
problems? I'm wondering if the chown() call is failing. Perhaps
postgres isn't a
On Fri, Nov 13, 2009 at 11:47 AM, Tom Lane wrote:
> Joe Miller writes:
> > I have a PostgreSQL installation for which I would like to limit local
> > domain socket access to the postgres user and members of the "myadmin"
> > group. I've modified pg_hba.conf to trust local domain socket
> connect
Joe Miller writes:
> I have a PostgreSQL installation for which I would like to limit local
> domain socket access to the postgres user and members of the "myadmin"
> group. I've modified pg_hba.conf to trust local domain socket connections,
> and changed these settings in postgresql.conf:
> unix_
I have a PostgreSQL installation for which I would like to limit local
domain socket access to the postgres user and members of the "myadmin"
group. I've modified pg_hba.conf to trust local domain socket connections,
and changed these settings in postgresql.conf:
unix_socket_group = 'myadmin'
unix
