On Tue, Jan 17, 2012 at 3:51 AM, Manoj Govindassamy
wrote:
>>> 1. Transaction which was stuck right when slave going away never went
>>> thru even after I reloaded master's config with local commit on. I do see
>>> all new transactions on master are going thru fine, except the one which was
>>> st
Question - user postgres
If the admin is creating various "postgresql" users to work on different
databases - is it advisable to create these as "LINUX" users so that they
have a home directory for saving their scripts - and while we are about it -
where would experienced postgresql admins (as us
anyone with PG Synchronous Replication knowledge, please help me with
your views on the below questions.
thanks,
Manoj
On 01/12/2012 10:12 AM, Manoj Govindassamy wrote:
any help on this is much appreciated.
thanks,
Manoj
On 01/11/2012 01:50 PM, Manoj Govindassamy wrote:
Hi,
I have a P
Hi admins,
I've got a question according a setup including LDAP and local users.
Currently we do have kind of a double setup: Local users that are
assigned to roles but authenticating via LDAP.
Issue is now: It happens that the user's access is expiring from
database point of view, but user is sti
Hi folks,
We've got to monitor replication status (and lag) of a few 9.1.2
replicas and I'm trying to use values in master's pg_stat_replication to
do so.
The documentation [1] on postgresql.org doesn't explains exactly the
internals, especially what the *_location values means. What I'm doi