Re: [ADMIN] check_postgres monitor by Bucardo - any opinions?

Thanks Scott - do you ship the output to Nagios? On Thu, Oct 20, 2011 at 4:10 PM, Scott Marlowe wrote: > On Thu, Oct 20, 2011 at 12:16 PM, Mark Steben > wrote: > > Hi all, > > I'm evaluating the check_postgres program. We are running postgres 8.3. > > Does anybody

[ADMIN] check_postgres monitor by Bucardo - any opinions?

anything germaine to check_postgres. Thank you, -- *Mark Steben @ @utoRevenue* * * <http://www.autorevenue.com/>

[ADMIN] pgpool authenticatin issues

hed any light as to what I'm doing wrong? Thank you, Mark Steben Database Administrator @utoRevenue | Autobase | AVV The CRM division of Dominion Dealer Solutions # pgpool Client Authentication Configuration File # === # # The form

[ADMIN] password administration

like to use The 'rolvaliduntil' column in pg_roles. I'm wondering if there is an app inside or outside of postgres that I can use or do I have to design from scratch. Thanks for your time, Mark Steben | Database Administrator  @utoRevenue® - "Keeping Customers Close"  95

[ADMIN] ctrl-c - is it safe to kill a query?

ransaction did roll back. Good to know for future reference. Thank you. Mark Steben | Database Administrator <http://www.autorevenue.com> @utoRevenueR - "Keeping Customers Close" 95D Ashley Ave, West Springfield, MA 01089 413.243.4800 x1512 (Phone) |413.732-1824 (Fax)

[ADMIN] postgres on Windows

inted to would be most appreciated. Thank you, Mark Steben│Database Administrator @utoRevenueR-"Join the Revenue-tion" 95 Ashley Ave., West Springfield, Ma 413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax) @utoRevenue is a registered trademark and a division of Dominion Enterprises

[ADMIN] encoding error in new Postgres version

erence. Any help appreciated. Thank you, Mark Steben│Database Administrator @utoRevenueR-"Join the Revenue-tion" 95 Ashley Ave., West Springfield, Ma 413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax) @utoRevenue is a registered trademark and a division of Dominion Enterprises

[ADMIN] Question on start server using PG_CTL

fter start command - perhaps I need to sleep for 5 seconds before the test). Thanks for your time, Mark Steben│Database Administrator @utoRevenueR-"Join the Revenue-tion" 95 Ashley Ave., West Springfield, Ma 413-243-4800 x1512 (Phone) │ 413.732-1824 (Fax) @utoRevenue is a registered tradema

Re: [ADMIN] Concurrency question

closed and when we push this out, everything will once again Be right with the world. Thanks to all for the help. Mark Steben│Database Administrator│ @utoRevenue-R- "Join the Revenue-tion" 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax) @uto

[ADMIN] Concurrency question

that it hung because it was A transaction? Even so I thought those lock types were compatible. As always thanks for your time. Mark Steben│Database Administrator│ @utoRevenueR "Join the Revenue-tion" 95 Ashley Ave. West Springfield, MA., 01089  413-243-4800 x1512 (Phone) │ 413-732

[ADMIN] Hot standby

Great to see the announcement of the 8.4 rollout. Quick question - is hot standby available or still being worked on? I see mention of it in the pgsql admin archives but I don't see it in the documentation. Thanks, Mark Steben│Database Administrator│ @utoRevenueR "Join the Revenu

Re: [ADMIN] recovery question

00010C2800B1 came into xlog as 16777216, just like the others. Thanks for the response. Mark Steben│Database Administrator│ @utoRevenue-R- "Join the Revenue-tion" 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax) @utoRevenue is a

[ADMIN] recovery question

28/B1FFEC5C Feb 25 10:08:12 ar-db3 postgres[32538]: [9-1] @: LOG: invalid secondary checkpoint record Feb 25 10:08:12 ar-db3 postgres[32538]: [10-1] @: PANIC: could not locate a valid checkpoint record Feb 25 10:08:12 ar-db3 postgres[32537]: [1-1] @: LOG: startup process (PID 32538) was termin

Re: [ADMIN] pg_xlog volume question

ly availability And then to place back in 'recovery mode' for the next nights set of Logs But it doesn't lend itself to this type of application. Mark Steben│Database Administrator│ @utoRevenue-R- "Join the Revenue-tion" 95 Ashley Ave. West Springfield, MA., 01089 413-24

[ADMIN] pg_xlog volume question

ut 2GB of logs every hour. Is there a config parameter to reduce the amount that Xlog takes up? At this rate I'm looking at close to 400GB to restore the database at the end of the week. Any help appreciated. Mark Steben│Database Administrator│ @utoRevenue-R- "Join the Revenue-tion&q

[ADMIN] FW: Warm Standby - log shipping

81 log? Thanks, Mark Steben│Database Administrator│ @utoRevenue-R- "Join the Revenue-tion" COME SEE US AT NADA BOOTH #1021, HALL B, IN NEW ORLEANS! 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax) @utoRevenue is a registered tradema

Re: [ADMIN] Warm Standby - log shipping

Thanks for the clarifications Kevin, Josh, Simon I am trying out Kevin's suggestion to create a second standby copy now. I know I have to create the base copy and send it over, at least For the first time to start recovery. I will look at rsync to do that. Thanks for all the help -- Mark I'm not

Re: [ADMIN] Warm Standby - log shipping

then we will. I just want to make sure I'm understanding your advice. Thanks Mark Steben│Database Administrator│ @utoRevenue-R- "Join the Revenue-tion" COME SEE US AT NADA BOOTH #1021, HALL B, IN NEW ORLEANS! 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone)

[ADMIN] Warm Standby - log shipping

a log got partially copied and postgres cannot find a valid checkpoint to restart. What is the best way to remedy this situation? Pg_resetxlog perhaps? Thanks for your help Mark Steben│Database Administrator│ @utoRevenue-R- "Join the Revenue-tion" COME SEE US AT NADA BOOTH #1021, HALL B

[ADMIN] warm standby

ng @utoEnthusiasts. Please provide us with your feedback. _ Mark Steben│Database Administrator│ <http://www.autorevenue.com/> @utoRevenueT 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax) A Division of Dominion Enterprises

Re: [ADMIN] question on warm standby

-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2008 10:06 PM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] question on warm standby "Mark Steben" <[EMAIL PROTECTED]> writes: > I am running postg

[ADMIN] question on warm standby

ast this, then I can play around with pg_standby and get Real warm_standby started. Thanks for your help, Committed to Creating @utoEnthusiasts. Please provide us with your feedback. ________ Mark Steben│Database Administrator│ @utoRevenueT 95 Ashley Ave. West Springfield,

[ADMIN] backup server - how to disconnect

specific PIDs. Not something I want to do manually at 1 am every morning. We are at postgres 8.2.5. Thanks for your help <mailto:[EMAIL PROTECTED]> Committed to Creating @utoEnthusiasts. Please provide us with your feedback. _____ Mark Steben│Database Administrator│

[ADMIN] transaction status error

meantime, any ideas on how To fix this? Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.

Re: [ADMIN] error message in PITR restore:

Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax [EMAIL PROTECTED] Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this

[ADMIN] error message in PITR restore:

t the checkpoint request failed. Is there any way replay the restore to get out of this pickle, or do I start from scratch? Fortunately this is a development server so I have the luxury of recopying production. Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterp

Re: [ADMIN] auto_vacuum question

Thanks Alvaro - did as you suggested and looks to be working better Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax [EMAIL PROTECTED] Visit our new website at

[ADMIN] auto_vacuum question

s vacuumed manually during the day do have this LAST_VACUUM column updated. The autovacuum does populate the LAST_AUTOVACUUM column For these tables. Any insights? Thanks Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee

[ADMIN] Newly converted to 8.2.5 and getting this error

Any help would be appreciated. Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.com Visit ou

Re: [ADMIN] Error on CLUSTER command

The doc says to do an initdb and reload the data whenever you run pg_resetxlog. Do you concur with that even if we are only resetting the OID counter? -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, February 08, 2008 11:36 AM To: Mark Steben Cc: pgsql-admin

Re: [ADMIN] Error on CLUSTER command

] Sent: Friday, February 08, 2008 11:19 AM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Error on CLUSTER command "Mark Steben" <[EMAIL PROTECTED]> writes: > I am getting the following error when I attempt to CLUSTER on a table: > mavmail=# cluster mailer_

[ADMIN] Error on CLUSTER command

eduled for implementation later this month or early March. Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.c

[ADMIN] production error

Hi folks, getting this error in production: unexpected chunk number 0 (expected 1) for toast value 34761 Any ideas on how to approach this? Two of the tables in the query have toast tables, one does not. Thanks, Mark Steben Senior Database Administrator @utoRevenueT A

Re: [ADMIN] no entry on pg_database for a live database

Thanks Tom - that did the trick We will be upgrading to 8.2 within the next couple weeks. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 22, 2008 12:20 PM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] no entry on pg_database for a

[ADMIN] no entry on pg_database for a live database

this? Any ideas would be appreciated Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.com Vis

Re: [ADMIN] reconfiguring diskspace while upgrading to 8.2.5

All feedback would be appreciated. Thank you, Mark Steben _ From: Mark Steben [mailto:[EMAIL PROTECTED] Sent: Friday, December 28, 2007 10:09 AM To: 'pgsql-admin@postgresql.org' Cc: '[EMAIL PROTECTED]'; 'David Parks'; 'Craig Brothers' Sub

[ADMIN] reconfiguring diskspace while upgrading to 8.2.5

massive growth over the Next 2 - 3 years. Any thoughts / comments would be appreciated. Also are there tools out there that monitor disk I/O and disk speed? Thanks for your time, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480

[ADMIN] Looking for an E/R tool for Postgres

Does anybody have suggestions as to what Entity_Relationship diagram tool Is out there that'll work for Postgres? Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office

[ADMIN] where can I find doc for pg_buffercache?

n to be 8.2.5 per Scott M.) Thanks, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.com Vis

[ADMIN] Maintenance_work_mem question

ffers. I know this is Very large for 7.4.5 but may be more appropriate for 8.2.4. Any thoughts? Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporat

Re: [ADMIN] bgwriter update question

Thanks Tom, every piece of new information adds to my education. I'm going to put to bed this effort of trying to verify BGWRITER, knowing that it works in 8.2 and move on. Regards, Mark Steben -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2

[ADMIN] bgwriter update question

emain in memory until syncpoint in pre-8.0. Am I missing somethng? Thanks for your time Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[

[ADMIN] BGWRITER in Postgres 8.2

I would like to test the new components of 8.2 as we upgrade from 7.4 next month. Is there any way to verify that the background writer is operational? Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA

[ADMIN] postgres 8.2.4 new installation - trying to get autovacuum to work

where? Log_min_duration_statement currently set to 2000 milliseconds. The updates show in the logs. The vacuum does not. Any help would be appreciated. Thank you, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 41

[ADMIN] Mass updates on a large table

is up? We simply cannot afford this table to be down for 3+ days during a production update. The production box is a 32meg RAM box. We are at Postgres 7.4.5. Thanks for your time and brainpower Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 48

[ADMIN]

could not send data to client: Broken pipe There is no pattern or record that we see causing this error. When we run this manually on the local machine we do not get this error. It is a Postgres function that is called. I would appreciate any insight into this matter. Thank you,

[ADMIN] update within trigger function

r function. Is there a command within plpgsql that can help me with this? This seems like an elementary question, but I am a very elementary user of Postgres functions. Thank you for your time, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480

[ADMIN] row level locking

currently at version 7.4.5. Thank you for your time, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben mailto:[EMAIL PROTECTED]> @autorevenue.

[ADMIN] Index on a COALESCE function

01-01')+timespan('45 days')), date(service_date+timespan('44 days', date(null),date(create_date),9,false) as send_date,last_send I can't seem to get this index to work on the function, just on the cid column. Any ideas would be appreciated Thank you, Mar

[ADMIN] REINDEX question

hy this is happening and what I can do in the short term? I know we are at a back-leveled version so perhaps the long-term answer is to upgrade. Thank you, Mark Steben Senior DBA - AutoRevenue Direct dial phone number: 413-327-3045 Please visit our new website at www.autorevenue

Re: [ADMIN] Question on partitioning

Simon, you're right on the money.. the guys on the IRC chatroom suggested that I cast the partitioning column as SMALLINT as the optimizer assumed Integer and it worked. Thx for getting back to me Mark Steben AutoRevenue -Original Message- From: Simon Riggs [mailto:[EMAIL PROT

[ADMIN] Question on partitioning

also Does index scans on partitions 2, 3, and 4 which I did not expect since I limited the range in my WHERE clause to rows in partition 1. Do I need to load more data?  Any help would be appreciated.  I did set my CONSTRAINT_EXCLUSION to ON.   Thank  you, Mark Steben   From: Mark

[ADMIN] Question on partitioning

table that would reference ENTRY-DATE across partitions or will I need to build indexes and queries on each partition?   Thank you for your time, Mark Steben From: Mark Steben [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 3:18 PM To: 'pgsql-admin@postgresql.org

Re: [ADMIN] Question

, 2006 3:29 PM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Question On Tue, 7 Nov 2006, Mark Steben wrote: > I am very new to PostgreSQL. Is it appropriate to pose questions to this > email list? It might be better on pgsql-sql, but I'm not sure. > I am try

[ADMIN] Question

figure out how to get the index name from there.  Any help would be appreciated. And, if this is not an appropriate forum to ask questions please tell me.   Thank you, Mark Steben   AutoRevenue

[ADMIN] New to PostgreSQL

me as I basically Self-educate.   Thank you and I look forward to working with you through your mailing list.   Mark Steben AutoRevenue Lee, Massachusetts [EMAIL PROTECTED]