Re: [GENERAL] Fresh Restore - relation contains more than "max_fsm_pages"

2011-07-29 Thread Maton, Brett
Thanks Craig, Is there a query I can run to check if the Fill Factor was changed ? The restore was executed as a single pg_restore, rather than schema then data I'm trying to get PG upgraded to 8.4, but you know it is.. Brett On 29 July 2011 04:56, Craig Ringer wrote: > On 28/07

[GENERAL] repmgr and archive_mode

2011-07-29 Thread Toby Corkindale
Hi, In the repmgr README, it suggests configuration should include: archive_mode = on archive_command = 'cd .' Could someone explain why we need archive_mode enabled? In my own testing of Pg's streaming replication, I've found it to work without this enabled. Cheers, Toby -- Sent via pgsql-

Re: [GENERAL] repmgr and archive_mode

2011-07-29 Thread Raghavendra
On Fri, Jul 29, 2011 at 1:42 PM, Toby Corkindale < toby.corkind...@strategicdata.com.au> wrote: > Hi, > In the repmgr README, it suggests configuration should include: > > archive_mode = on > archive_command = 'cd .' > > Could someone explain why we need archive_mode enabled? In my own testing > o

[GENERAL] [ADMIN] how much work_mem is my server using

2011-07-29 Thread Willy-Bas Loos
Hi, Is there a way to find out how much work_mem my server(*) is actually using on a running system in production? * - session or cluster. I don't mean explain analyze. What i am really interested in is: how does postgres utilize the memory in the server? How much goes where, in reality. I want t

[GENERAL] Queries related to checkpoints

2011-07-29 Thread Rohan Malhotra
Hi, I am a Noob with db tuning and trying to analyze pg_stats_brwriter data checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc ---+-++---+--

Re: [GENERAL] repmgr and archive_mode

2011-07-29 Thread Adrian Klaver
On Friday, July 29, 2011 1:23:55 am Raghavendra wrote: > On Fri, Jul 29, 2011 at 1:42 PM, Toby Corkindale < > > toby.corkind...@strategicdata.com.au> wrote: > > Hi, > > In the repmgr README, it suggests configuration should include: > > > > archive_mode = on > > archive_command = 'cd .' > > > >

Re: [GENERAL] How to implement autostart of postgres?

2011-07-29 Thread Tom Lane
Craig Ringer writes: > On 28/07/11 18:06, Gavrina, Irina wrote: >> Is there any risk of losing of data or data corruption in this case? > Possibly, if you then remove postmaster.pid, thus bypassing the other > safety, and start a new postmaster. > I'm a bit alarmed to discover that Ubuntu's post

Re: [GENERAL] query_to_xml nulls set to false

2011-07-29 Thread Peter Eisentraut
On mån, 2011-07-11 at 18:54 -0700, Lynn Dobbs wrote: > I am using query_to_xml with nulls set to false in postgresql 9.0.4. > (I believe the behavior was also present in 8.4.) > > The documentation for query_to_xml says that if set to true, nulls > with be treated with xsi:nil="true" and "An appro

[GENERAL] Newbiee Pls help.....

2011-07-29 Thread woow
I have following function expectation is I want to return the items in array soI could call this from another function where I could traverse through the each array element CREATE OR REPLACE FUNCTION get_role_id_list_for_type(INTEGER) RETURNS INTEGER[] AS $$ DECLARE rolelis

Re: [GENERAL] [PERFORM] Queries related to checkpoints

2011-07-29 Thread Kevin Grittner
Rohan Malhotra wrote: First off, for a one-row result with too many values to fit on one line, you might want to use this in psql: \x on More importantly, you seem to be misinterpreting the numbers. You've allocated 2,205,969,940 buffers. Of those allocations, the allocating backend had t

[GENERAL] Factors Influencing Participant Satisfaction with Free/Libre and Open Source Software Projects

2011-07-29 Thread Brent Wood
Apologies for the cross posting, but this thesis may be of interest to a wide array of FOSS related lists. It just went public: Title:     Factors Influencing Participant Satisfaction with Free/Libre and Open Source Software Projects Author:     Chawner, Brenda Abstract:     The purpose of thi

Re: [GENERAL] Newbiee Pls help.....

2011-07-29 Thread Jens Wilke
On Freitag, 29. Juli 2011, woow wrote: > I have following function expectation is I want to return the > items in array > SELECT INTO rolelist role_id FROM roles WHERE role_type = > $1; RETURN rolelist; Hi, you've to use array_agg: SELECT INTO rolelist array_agg(role_id) FROM roles

[GENERAL] Finding referecing and referenced tables, adaptation from David Fetter's solution

2011-07-29 Thread bricklen
A coworker of mine* was looking for a way to quickly and easily be able to tell which tables were referencing particular table(s) she wanted to load (for unit testing). Using the examples from David Fetter**, she submitted a revised version that seems to work quite well. With her permission, I have

Re: [GENERAL] repmgr and archive_mode

2011-07-29 Thread Jaime Casanova
On Fri, Jul 29, 2011 at 3:12 AM, Toby Corkindale wrote: > Hi, > In the repmgr README, it suggests configuration should include: > > archive_mode = on > archive_command = 'cd .' > > Could someone explain why we need archive_mode enabled? In my own testing of > Pg's streaming replication, I've found

Re: [GENERAL] repmgr and archive_mode

2011-07-29 Thread Toby Corkindale
- Original Message - > wrote: > > Hi, > > In the repmgr README, it suggests configuration should include: > > > > archive_mode = on > > archive_command = 'cd .' > > > > Could someone explain why we need archive_mode enabled? In my own > > testing of > > Pg's streaming replication, I've fou