[ADMIN] check_postgres monitor by Bucardo - any opinions?

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

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 scott.marl...@gmail.comwrote: On Thu, Oct 20, 2011 at 12:16 PM, Mark Steben mark.ste...@autorevenue.com wrote: Hi all, I'm evaluating the check_postgres program. We are running postgres 8.3

[ADMIN] password administration

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  95D Ashley Ave, West Springfield

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

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

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

, 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

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 trademark and a division

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) @utoRevenue

[ADMIN] Concurrency question

it be 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-1824 (Fax

[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 Revenue-tion 95

[ADMIN] recovery question

the same error. So, is there a way that I can force the recovery to begin at B2 or am I dead in the water and need to bring in another full file copy and Start from scratch: Thanks for your time. Mark Steben│Database Administrator│ @utoRevenue-R- Join the Revenue-tion 95 Ashley Ave. West

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 registered

[ADMIN] pg_xlog volume question

. 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 95 Ashley Ave. West Springfield, MA

Re: [ADMIN] pg_xlog volume question

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-243-4800 x1512 (Phone) │ 413-732-1824 (Fax

[ADMIN] FW: Warm Standby - log shipping

? 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 trademark and a division

Re: [ADMIN] Warm Standby - log shipping

this 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) │ 413-732-1824 (Fax

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

[ADMIN] warm standby

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 postgres 8.3.4 on master

[ADMIN] question on warm standby

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, MA., 01089 413-243

[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│ http

[ADMIN] transaction status error

seems to be hosed. I can do a CREATE DATABASE from template0 but the new database Gets the same access status error. We are ok unless we access template0. And yes, we plan to upgrade to 8.x sometime next month. In the meantime, any ideas on how To fix this? Thank you, Mark Steben

[ADMIN] error message in PITR restore:

that 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 Enterprises

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

[ADMIN] auto_vacuum question

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, MA 01238

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

[ADMIN] Newly converted to 8.2.5 and getting this error

. 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 blocked::mailto:[EMAIL PROTECTED] @autorevenue.com Visit our new website at blocked

[ADMIN] Error on CLUSTER command

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 blocked::mailto:[EMAIL PROTECTED] @autorevenue.com

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_queue; ERROR: could

[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

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

Re: [ADMIN] reconfiguring diskspace while upgrading to 8.2.5

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' Subject: reconfiguring diskspace while upgrading

[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 413

[ADMIN] where can I find doc for pg_buffercache?

.) 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 blocked::mailto:[EMAIL PROTECTED] @autorevenue.com Visit our new website at blocked

[ADMIN] Maintenance_work_mem question

. 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 Corporate Fax

[ADMIN] bgwriter update question

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 blocked::mailto

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, 2007 2

[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

? 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 413-243

[ADMIN] update within trigger function

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 Pleasant Street Suite B200 Lee, MA 01238

[ADMIN] Index on a COALESCE function

')), 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, Mark Steben Senior Database Administrator @utoRevenueT

[ADMIN] REINDEX question

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.com http

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 PROTECTED

[ADMIN] Question on partitioning

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 Steben [mailto

[ADMIN] Question on partitioning

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' Subject: Question

[ADMIN] Question

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

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 trying to come up

[ADMIN] New to PostgreSQL

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