Re: [ADMIN] Couldn't start postgres, got no logging, ran postgres manually for info-- help?

- 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

Re: [ADMIN] Creating new cluster by copying directory?

--- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: http://www.kaspersky.com, http://www.viruslist.com -- Wells Oliver wellsoli...@gmail.com -- Jerry Sievers Postgres DBA/Development Consulting e

Re: [ADMIN] Dump/Reload pg_statistic to cut time from pg_upgrade?

Kevin Grittner kgri...@ymail.com writes: Jerry Sievers gsiever...@comcast.net wrote: Planning to pg_upgrade some large (3TB) clusters using hard link method.  Run time for the upgrade itself takes around 5 minutes. Nice!!  Origin version 8.4 and destination version 9.1. Unfortunately

[ADMIN] Dump/Reload pg_statistic to cut time from pg_upgrade?

,_income,_liabilities,assets,income,liabilities} Setting allow_system_table_mods to 'on' is required also prior to attempting the import. Has anyone else attempted anything similar? Any feedback is appreciated. Thanks -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult

[ADMIN] Escaping a blocked sendto() syscall without causing a restart

) SIGRTMAX-14 51) SIGRTMAX-13 52) SIGRTMAX-12 53) SIGRTMAX-11 54) SIGRTMAX-10 55) SIGRTMAX-9 56) SIGRTMAX-8 57) SIGRTMAX-7 58) SIGRTMAX-6 59) SIGRTMAX-5 60) SIGRTMAX-4 61) SIGRTMAX-3 62) SIGRTMAX-2 63) SIGRTMAX-1 64) SIGRTMAX $ Thanks -- Jerry Sievers e: jerry.siev...@comcast.net p

Re: [ADMIN] Unable to reload postgresql.conf without restarting

posgres 9.1 on Centos Linux (amazon ec2) Thanks -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [ADMIN] standby with a fixed lag behind the master

@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 732.216.7255 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

Re: [ADMIN] Oldest xmin is far in the past

is from early this morning. See if there is a prepared transaction still open. Query pg_prepared_xacts. HTH -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 732.216.7255 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

Re: [ADMIN] Creating a Read Only profile in 8.4

connected as RO_User and did a select against a simple table in the DB, I got access denied on the table. Can anyone point to my error? Greg Della-Croce -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 732.216.7255 -- Sent via pgsql-admin mailing

Re: [ADMIN] pg_basebackup blocking all queries with horrible performance

, then any sort of throttling mechanism should work. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p

Re: [ADMIN] logging issue

. -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] error during PITR

: error during PITR Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription

Re: [ADMIN] lock problem

, we'd all be running around in a darkened room munching pills and listening to repetitive music. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Jerry Sievers Postgres DBA

Re: [ADMIN] trigger statistics?

this setting. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql

Re: [ADMIN] Recover from failover

. This is the conventional and guaranteed to work approach. HTH Cheers, Martin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Jerry Sievers Postgres DBA/Development Consulting e

Re: [ADMIN] rsync and streaming replication

the data from the new master to the other slaves ? Did I miss anything ? Any idea ? Jean-Armel -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

Re: [ADMIN] Frequency of archive_cleanup_command

Thanks. -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Dump SQL DDL of all functions in DB

: (250) 260 ó 4351 ext. 13 * For up to the minute news, support notifications and other pertinant information regarding your website or related services, you can use the following resources: Twitter | Facebook | Support Website -- Jerry Sievers Postgres

Re: [ADMIN] Gbtreekey16 type

bury me when I'm gone Do you teach me while I'm here Just as soon I belong Then it's time I disappear -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

Re: [ADMIN] Switchover of Master and Slave roles

(pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

Re: [ADMIN] PKs without indexes

contype = 'p' ); abort; HTH Thanks, John John P Weatherman Sr Database Administrator Centerstone -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

Re: [ADMIN] Warm Standby on 8.4.7

a configurable time lag from production, I made some minor mods to our version of the standby script, now written in Python, to make it happen. WALs now have to pass sanity and aging checks before being applied. HTH -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p

Re: [ADMIN] Version String

  === Samuel Nelson Consistent State www.consistentstate.com 303-955-0509 === -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your

Re: [ADMIN] unsupported header version error

does pg_ctl --version say? If those 2 bits suggest a match, then have you gone from 32-64 bit or crossing machine hw architectures? regards, Fredy Khan -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

Re: [ADMIN] Out of memory during index creation

m'en aviser imm?diatement, par retour de courriel ou par un autre moyen. Mail sent via the Abaca EPG -- -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144

Re: [ADMIN] Index size growing

. Since you can't reindex without blocking anyway, I assume you are clear of concurrency issues to prevent using this advice (apps down and/or quiescent). -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql

Re: [ADMIN] ls /var/lib/pgsql/data nothing

might even show something after the -D option for some sites if DB is running also. Why? I need to find the pg_h.conf file but not able. Do you mean pg_hba.conf? Any help? Regards Bilal -- Jerry Sievers e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql

Re: [ADMIN] How do you upgrade for production servers?

-- --- Jerry Sievers 305 854-3001 (home) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant ---(end of broadcast)--- TIP 4: Have you searched our

Re: [ADMIN] How to enforce the use of the sequence for serial columns

---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- --- Jerry Sievers 305 854-3001 (home) Production Database Administrator

Re: [ADMIN] validating incoming string length...

-- --- Jerry Sievers 305 854-3001 (home) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] Manual sys catalog constraint setup to avoid downtime?

Jim C. Nasby [EMAIL PROTECTED] writes: On Tue, Nov 07, 2006 at 11:05:38AM -0500, Jerry Sievers wrote: Admins; this is (I assume) a not uncommon scenario). Suppose you are managing a BIG ugly DB that's in 24x7 production and desperately in need of constraints of all types

[ADMIN] Manual sys catalog constraint setup to avoid downtime?

what non-obvious pitfalls exist here? Comments? -- --- Jerry Sievers 305 854-3001 (home) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant

[ADMIN] OID cache lookups failing

'); relname --- problem_table (1 row) The low numbered OID rec is the one showing above. Any ideas how to fix? This is on a busy prod system. Reindexing pg_class worth a try? Thanks -- --- Jerry

[ADMIN] OID cache, oops forgot version()

) -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] pg_restore index/trigger restoration issue

in the table schema listing. As for what opts pg_dump and pg_restore offer, see the manual. --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp

[ADMIN] Postmaster log perms and line suffix

each log file entry? Prefix can be used for this but seems a bit non-intuitive. Comments appreciated. Thx -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobile

Re: [ADMIN] pg_stat_activity showing non-existent processes

Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] writes: At any rate; I'm wondering what possible causes might be responsible for pg_stat_activity's underlying functions to lose track of the valid process list? It sounds like the stats collector missed a few backend

[ADMIN] pg_stat_activity showing non-existent processes

! -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

[ADMIN] Curious run-away index build on upgrade to 8.1.3

welcome. If it would be of interest to someone that I truss one of the spinning processes, I can redo this in an RD setting and submit the results. Thank you! -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce

Re: [ADMIN] Curious run-away index build on upgrade to 8.1.3

Hi Tom, thanks for responding on this. More below; Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] writes: What happened was that for a couple minutes the CPU load would steadily increase and disk activity decrease at the same time. Before long, one CPU is 100% busy

Re: [ADMIN] Curious run-away index build on upgrade to 8.1.3

Hi Tom; Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] writes: Platform is Solaris 2.9 I think this might be the key... I can reproduce an unreasonably long runtime if I use src/port/qsort.c (as we do on Solaris), but not with glibc's version of qsort. I think you

Re: [ADMIN] Curious run-away index build on upgrade to 8.1.3

scratch on 8.0, with the data ordered as it was when I made the original dump, it would have stalled all the same. I just reproduced this on an 8.0.3 box. FYI -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce

[ADMIN] Dropping of indexes with cached PL query plans

methodology. Comments? -- --- Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305 321-1144 (mobilehttp://www.JerrySievers.com/ ---(end of broadcast

Re: [ADMIN] Dropping of indexes with cached PL query plans

Tom Lane [EMAIL PROTECTED] writes: Jerry Sievers [EMAIL PROTECTED] writes: Any of these connections that may have previously executed PL functions which planned an index lookup are now going to fault if same index goes away. Had wondered if a postmaster 'reload' would elicit