Re: [ADMIN] PG synchronous replication and unresponsive slave

2012-01-16 Thread Fujii Masao
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

[ADMIN] apt installation postgresql 8.3

2012-01-16 Thread David M. Gullever
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

[ADMIN] PG synchronous replication and unresponsive slave

2012-01-16 Thread Manoj Govindassamy
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

[ADMIN] LDAP vs. local users

2012-01-16 Thread Frank Lanitz
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

[ADMIN] Interpreting pg_stat_replication values

2012-01-16 Thread Alexander Fortin
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