Re: [ADMIN] DBD::Pg requires at least protocol version 3.0

v" via your packaging system. - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201308262204 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAlIcCUQACgkQvJuQZxSWSsi2Rg

Re: [ADMIN] DBD::Pg requires at least protocol version 3.0

compile against as well. - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201306082310 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAlGz8m8ACgkQvJuQZxSWSsh7uACg

Re: [ADMIN] Getting

if you doing an update / insert / delete you may want to wrap it in an explicit transaction and then roll it back. HTH, Greg Williamson -- 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] Mapping a Data File Back to a Table

It was stored in pg_largeobject based on the OID. On Fri, Jan 04, 2013 at 11:09:33AM -0700, Greg Schenzel wrote: > So I've been digging through a database on an embedded device for two > days trying to figure out which table some data is stored in. There > are litterally 1000

[ADMIN] Mapping a Data File Back to a Table

So I've been digging through a database on an embedded device for two days trying to figure out which table some data is stored in. There are litterally 1000 tables in the database and I haven't come across the right one(s) yet. I know that the data I'm looking for is stored in /var/lib/pgsql/data/

Re: [ADMIN] autovacuum

d might help with whatever problem you think autovac is causing. HTH, Greg Williamson -- 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] Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown

Rafael -- <...> >> Has anyone else seen anything like this ? >> > > Hello > > The release notes for 9.2.2 say this: > > "... However, you may need to perform REINDEX operations to correct > problems in concurrently-built indexes, as described in the first > changelog item below." > > Bu

[ADMIN] Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown

config  settings to see if anything changed (shouldn't have but ...). Has anyone else seen anything like this ? I  suspect some site error had led to us scoring an own-goal but I thought I'd ask and see if anyone else has seen this. Thanks, Greg Williamson -- Sent via pgsql-adm

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

Tom -- >Greg Williamson writes: >> We want to create a role used by a monitor to check for " in >> Transaction" with the most restrictive permissions we can on a 8.4.13 >> instance. > >> The user has been granted connect privilege to the database

[ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

e database and some limited permissions to user tabhles that need to be monitored. But pg_stat_activity shows only "" I've trolled the archives and postgres docs with no success. Could some kind soul point me in the right direction ? Thanks! Greg Williamson

Re: [ADMIN] Cronjob to autobackup database

ld not know about. If it does not run from the command line, that will probably give you a clue. HTH, Greg Williamson -- 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] Resolving Index Bloat

s of failures, never repeated. The hand rolled version is a bit safer and a little less intrusive. HTH, Greg Williamson -- 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] autovacuum with lots of open file references to deleted files

ROP DATABASE scenarios. > Is there any idea of when this will be released ? Thanks, Greg W. -- 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] Database size stays constant but disk space keeps shrinking -- postgres 9.1

fantastic ! thanks. greg > > From: Jaime Casanova >To: Greg Williamson >Cc: "pgsql-admin@postgresql.org" >Sent: Wednesday, October 17, 2012 10:05 AM >Subject: Re: [ADMIN] Database size stays constant but disk space keeps >s

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

Gabriele -- - Original Message - > From: Gabriele Bartolini > To: Greg Williamson > Cc: pgsql-admin@postgresql.org > Sent: Wednesday, October 3, 2012 4:41 AM > Subject: Re: [ADMIN] Database size stays constant but disk space keeps > shrinking -- postgres 9.1 > &

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

I've done some more testing and the problem seems to be repmgr itself. A few details below... - Original Message - > From: Greg Williamson > To: Tom Lane > Cc: "pgsql-admin@postgresql.org" > Sent: Thursday, September 27, 2012 7:23 PM > Subject: R

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

Dinesh -- - Original Message - > From: Dinesh Bhandary > To: Greg Williamson > Cc: "pgsql-admin@postgresql.org" > Sent: Thursday, September 27, 2012 7:19 PM > Subject: Re: [ADMIN] Database size stays constant but disk space keeps > shrinking -- postgr

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

Steve -- - Original Message - > From: Steve Crawford > To: Greg Williamson > Cc: "pgsql-admin@postgresql.org" > Sent: Friday, September 28, 2012 8:59 AM > Subject: Re: [ADMIN] Database size stays constant but disk space keeps > shrinking -- postgres 9.1

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

Tom -- - Original Message - > From: Tom Lane > To: Greg Williamson > Cc: "pgsql-admin@postgresql.org" > Sent: Thursday, September 27, 2012 7:55 PM > Subject: Re: [ADMIN] Database size stays constant but disk space keeps > shrinking -- postgres 9.1

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

Tom -- - Original Message - > From: Tom Lane > To: Greg Williamson > Cc: "pgsql-admin@postgresql.org" > Sent: Thursday, September 27, 2012 7:14 PM > Subject: Re: [ADMIN] Database size stays constant but disk space keeps > shrinking -- postgres 9.1

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

Steve (and others who replied): - Original Message - > From: Steve Crawford > To: Greg Williamson > Cc: "pgsql-admin@postgresql.org" > Sent: Thursday, September 27, 2012 3:48 PM > Subject: Re: [ADMIN] Database size stays constant but disk space keeps &g

[ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

database, and then drops it. I posted a message about ths a few days and got no responses. I am hoping for better luck this time as this is a serious issue,not relayed t vacuuming or routine admin tasks which may or may not be happening. Thanks for any help / advice / things to look for. Greg a

[ADMIN] file descriptors still open to deleted files

information if you give me some pointers as to what to look for. Thanks! Greg Williamson postgres(at)db11:5432=# select version();                                                    version

[ADMIN] creating trigger in 8.3 -- very slow

I've got a fairly large table (186 million rows) that is moderately busy ( a few inserts per second at most) that I am trying to create a trigger on --  it is just hanging. Can this be done in 8.3 ? Will it eventually complete ?  Thanks for any advice, information, etc.! Greg Williamson

Re: [ADMIN] Question about ALTER TABLE DROP CONSTRAINT on 9.1 -- psql crashes

Tom, et. al., > > From: Greg Williamson >To: Tom Lane >Cc: "pgsql-admin@postgresql.org" >Sent: Thursday, August 9, 2012 5:35 PM >Subject: Re: [ADMIN] Question about ALTER TABLE DROP CONSTRAINT on 9.1

Re: [ADMIN] Question about ALTER TABLE DROP CONSTRAINT on 9.1 -- psql crashes

g to shut off the cronjob and try this again). > > >It does not log an ERROR to the log file; I can wade intio the log and see >what else it says but it will take a little while (about 800 megs per hour) to >answer that. > > >Thanks, and I'll report back soon. > > >Greg >- > > > > >

[ADMIN] Question about ALTER TABLE DROP CONSTRAINT on 9.1 -- psql crashes

64-bit (1 row)   This table is only updated a few times a minute (mostly inserts and deletes, some updates), others get hit a lot more (many times a second). pgsql is the same version and I am on the same server. Is this known / documented ? Any suggestions (other than not to do this ; -- ) Thanks, Greg Williamson

Re: [ADMIN] replication recovery/startup question

recycling. You might also check pg_stat_replication to get an easier view of things, rather than relying on ps. ps is correct, it's just harder to check. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadra

Re: [ADMIN] autovac hitting too many tables at once

, all of which got autovac's attention. Given time everything calmed down and a lesson learned has been inscribed. Don't do mass deletes -- throttle them back, one way or another. If you must tread this path make some adjustments to relevant tables and values first. Thanks, Kevin, for the quick response. Greg W. -- 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] autovac hitting too many tables at once

gt; a VACUUM FREEZE ANALYZE. > > You might also want to consider running off-hours vacuums to > supplement autovacuum.  Upgrading to a more recent version of > PostgreSQL is likely to help some, too. > Duly noted. Thanks! Greg -- Sent via pgsql-admin mailing list (pgsql-ad

[ADMIN] autovac hitting too many tables at once

uture (other than going to manual vacuuming on a schedule). Thanks, Greg Williamson -- 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] about shared_buffer and kernel.shmmax

On 06/20/2012 11:38 PM, wangqi wrote: > shared_buffer maximum limit is ? > I set shared_buffer more than 250G, I got error at startup pg. There's not much evidence that values larger than 16GB are really productive. You really do not want put all their memory in just that one place

[ADMIN] View as front-end to function

back to the client. For the sake of argument, let's just say I have the most recent stable PostgreSQL installed. The API is Gdata-like for those of you who may be interested. Thoughts? Possible with a RULE or a TRIGGER? -Greg

Re: [ADMIN] Trouble w/ COPY command

type numeric in the table, and copy the values from the text variant to the numeric ones with the proper cast one at a time; if it blows up you go back to resolving issues. Then copy the table using the numeric columns to the desired destination. Hopefully others might have better ide

Re: [ADMIN] I've got gaps in the log files?

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I left them on defaults. > Actually they are even commented out. Never assume that the commented out version == default == actual value. Always explicitly set parameters you care about. - -- Greg Sabino Mullane g...@turnstep.com End

Re: [ADMIN] Monitor without superuser?

static/sql-createfunction.html -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail

[ADMIN] 32-bit to 64-bit migration options

when moving data from 32-bit to 64-bit? Option 3: pg_upgrade Is this an option? Remember, I'm going from 8.4 32-bit to 8.4 64-bit. Option 4: PITR I believe this is not a possibility because of the bit-ness change but I'm listing anyways in case I'm mistaken. Did I miss anything? TIA, Greg

Re: [ADMIN] postgres 9.0 date aberration in logs

ate_on_rotation  postgresql.conf log_truncate_on_rotation = on# If on, an existing log file of the Is it possible that this fails under some conditions ?  We are migrating to 9.1, which unfortunately showed the same issues at almost the same time; no complaints in system logs or restarts of the servers. Ver

[ADMIN] postgres 9.0 date aberration in logs

sf1ddb001 puppet-agent[28309]: Finished catalog run in 10.16 seconds Feb  7 01:27:43 sf1ddb001 puppet-agent[28309]: Finished catalog run in 10.86 seconds Feb  7 01:57:59 sf1ddb001 puppet-agent[28309]: Finished catalog run in 10.48 seconds <...> Has anyone ever seen anything like this ?  T

[ADMIN] 9.1 QUestion -- directory left over after drop database

0 Feb  6 14:49 1577013889 -rw--- 1 postgres postgres 0 Feb  6 14:49 1577011574 -rw--- 1 postgres postgres 0 Feb  6 14:49 1577011572 -rw--- 1 postgres postgres 0 Feb  6 14:49 1577011568 Are these safe to delete these files ? Is it safe to delete the directory itself ? Th

Re: [ADMIN] stats and unix sockets

n paranoid modes :) > > Can you create a virtual network interface, assign an address to it and have PostgreSQL listen to it in addition to the socket? I'm thinking not the eth0:X type but potentially what VirtualBox (vboxnet0), VMware (vmnet0) or other virtualization products do using brctl. Greg

Re: [ADMIN] Giving postgres roles 'sudo'-like access

://archives.postgresql.org/pgsql-hackers/2011-12/msg00822.php You might use some of that code and make your own pg_cancel_backend-like function that loads into the database. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

Re: [ADMIN] cancelled queries on standby

e canceled when those cleanup records are replicated. The fact that A is never changed and doesn't have autovacuum enabled doesn't matter. Because it's possible for Q to see B, it's canceled regardless of whether it's looked at it yet. -- Greg Smith 2ndQuadrant US

Re: [ADMIN] background writer being lazy?

y lowering that a lot. The 256MB to 1GB range is where I normally end up on servers where lower latency is prioritized instead of maximum throughput. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

Re: [ADMIN] audit trail for viewed data

the database and application changes easy (e.g. no changes at all!) at the high cost of parsing the logs when you need to make sense of them. - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201110290019 http://biglumber.com/

Re: [ADMIN] postgres 9.0.4, pg_restore and indexes

> Did you actually try this ? This does not include any references to indexes, constraints or sequences, all of which it might be useful to recreate. What I am I missing ? Or is pg_restore just not capable of restoring the full definition of a table ?  TIA, Greg WIlliamson -- S

[ADMIN] postgres 9.0.4, pg_restore and indexes

p without time zone |  Indexes:     "index_hosts_on_name" btree (name)     "index_hosts_on_source_file_id" btree (source_file_id) Could someone hit with me with a clue stick ? I've tried endless combinations of ways to restore the whole table with all indexes and hav

Re: [ADMIN] streaming replication and wraparound vacuuming

tive. Aim to commit and freeze as fast as possible afterwards, avoiding some of the intermediate writes you might otherwise see. That's the best that can be done without some hacking on the server code. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Tra

Re: [ADMIN] lo_import/lo_export in other table

it may serve your purposes. BTW, we went this route because INSERTs were taking far too long versus the lo_import() and INSERTs also have all their values echo'd to the database log file which slowed things down. HTH, Greg

Re: [ADMIN] replication from Oracle to PostgreSQL?

licensing an already built package would sell for. Companies who aren't willing to throw some money toward buying/customizing at least some PostgreSQL software, if it allows escaping from Oracle licensing, should reconsider their strategy. Not everything you'll want to make a conversion eas

Re: [ADMIN] snapshot backup with WAL files

estore using it. That would have discovered this problem during testing. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make

Re: [ADMIN] replication_timeout does not seem to be working

an that be accomplished ? You might be able to get what you want here by setting statement_timeout to 'n' seconds when doing a write transaction. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

Re: [ADMIN] How to start a database in ReadOnly mode?

d (HUP) Database-wide: ALTER DATABASE foobar SET default_transaction_read_only = true; - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201107090757 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEG

Re: [ADMIN] List all querys from a open transaction

orical level except in the database logs, so you would have to look there. - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201107052131 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -

Re: [ADMIN] Problem with Streaming Replication

er this year, synchronous replication is available on a per-transaction basis. That resolves the concern you have--important transactions can be confirmed on one of the slaves as a requirement before they commit. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD Comprehensive

Re: [ADMIN] How to change all owners on all objects in a schema

On Thu, Jun 23, 2011 at 2:41 PM, Kevin Grittner wrote: > "Kevin Grittner" wrote: > > > || ' set schema newschema;' > > Oops; you wanted to change the owner, but I'll leave that as an > exercise for the reader. :-) > > Beat me to it :) Replace , and psql -qAt -d -c "SELECT 'AL

Re: [ADMIN] How to pg_upgrade an 8.4.3 Installation

tem before, you might want to do the standard fix suggested using 8.4.8. But if this has always been an 8.4 system, you can just go right to 9.0.4. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "Po

Re: [ADMIN] Prepared statments: partial indexes are avoided!

n't get the one they started with to stop using prepared statements, and those gave them terrible query plans. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance"

Re: [ADMIN] tsvector limitations

e like from all periods; novels and the like that are no longer under copyright, so lots of long classics. <http://www.archive.org/stream/ataleoftwocities00098gut/old/2city12p_djvu.txt> for example ... 765K HTH, Greg Williamson -- Sent via pgsql-admin mailing list (pgsql-admin@postgr

Re: [ADMIN] Streaming replication status and fail over questions

r anything that crosses the two databases together. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-admin

Re: [ADMIN] calling pg_dump from perl

t to -f like so: E:\PostgreSQL\8.4SS\bin/pg_dump.exe -f "//nas-tb/DBBackups/PostgresDBBackup_TB-WS_misdwh_20110609151147.bak" -F p --clean -U postgres -h localhost misdwh - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x

Re: [ADMIN] patching the OS of a 9.0.4 db with hot standby

s properly. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To

Re: [ADMIN] Strange behavior of child table.

he plan will help confirm what's going on. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-admin mailing l

Re: [ADMIN] WAL and Checkpoints documentation

my book is the main extended commentary discussing this area available. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sen

Re: [ADMIN] archive_timeout behavior (8.4.6)

sure what differences between 8.4.6 and earlier 8.4 versions you think you've observed. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadran

Re: [ADMIN] Re: best practice for moving millions of rows to child table when setting up partitioning?

moving data over. Relying on the database's transactional scheme to avoid making any mistakes here--making it so a goof will ROLLBACK--and avoiding any need for downtime are normally higher priorities in a partition migration than making the move happen as fast as possible. -- Greg Smith 2ndQ

Re: [ADMIN] Version String

version() string, so as to return the correct version even after you upgrade. * Patch the standard ODBC driver to grep for just numbers in the version string, if they haven't already. - -- Greg Sabino Mullane g...@endpoint.com g...@turnstep.com End Point Corporation 610-983-

[ADMIN] Re: [HACKERS] Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

icient to clean up the problem if it was left-over. I wonder if it would help to write a regression test that runs 100 or so vacuums and see if the bulid farm turns up any examples of this behaviour. -- greg -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make change

Re: [ADMIN] Checkpoint and Background Writer Statistics

never meet its criteria. There's nothing wrong with that. Writing out dirty buffers only once per checkpoint is in theory the most efficient way to handle regularly changed data. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, a

Re: [ADMIN] Corrupted disk

ract the available data using the right data recovery techniques, especially if there's a pg_dump available too; we offer some services in this area. But if any serious changes are made to the database before we get to it, odds of successful recovery can drop fast. -- Greg Smith 2ndQ

Re: [ADMIN] Postgres on NAS/NFS

fiber-channel switch level is pretty straightforward. DAS running over fiber-channel can offer the same basic features though, it's just not as common to use a switch in that environment. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, a

Re: [ADMIN] Moving the data directory

ere is not the database's postgresql.conf, but instead the database cluster list you see when running pg_lsclusters. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": ht

Re: [ADMIN] how do you manage postgres 9's postgres process's memory

o how complicated systems are. Benchmarking yourself is the only reasonable defense against this very common problem. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance&qu

Re: [ADMIN] pg_* Tables

hat are the number of rows in those tables ? It is possible that the planner is doing a sequential scan because the tables are small and that's faster than doing indexed reads. Greg Williamson

Re: [ADMIN] pg_ctl: server does not shut down

about unclean shutdown, but no data should be lost. The "service" scripts don't do that though. You'll need to do something like this instead, presuming you start as root: su postgres pg_ctl -D /var/lib/pgsql/data -m immedate stop -- Greg Smith, 2ndQuadrant US g...@2ndquadra

Re: [ADMIN] Restricting schema sizes

experiment at just how long that timeout should be. If you set log_min_duration_statement (which is a general good idea in this situation anyway) and look at what kind of runtime common intense but not crippling queries take, that's one way to get feedback on where the timeout should be.

Re: [ADMIN] newer release branch

/wiki/Version_History that should provide some additional guidance if you read through them a bit. By the time you get that done, 9.0 should be a better tested and stable release, and you can do a quick binary upgrade from 8.4 to 9.0 using the pg_upgrade utility. -- Greg Smith, 2ndQuadrant

Re: [ADMIN] vacuum full table - internals in 8.3

ACUUM_FULL interesting as well. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, "PostgreSQL 9.0 High Performance"Pre-ordering at: https://www.packtpub.com/postgresql-9-0-high-performance/book

Re: [ADMIN] how to PG close session

ter integration with the application itself normally in the process. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, "PostgreSQL 9.0 High Performance"Pre-ordering at: https://www.packtpub.com/postgr

Re: [ADMIN] could not connect to server: Connection refused (0x0000274D/10061)

your system causing the problem instead, but from the fact that you're using the 192.168.*.* block I'd assume your client and the server are on the same local LAN. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQua

Re: [ADMIN] xid wraparound

server restart for. Those are the main three (along with maintenance_work_mem) that impact how fast VACUUM work progresses. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, "PostgreSQL 9.0 High Performan

Re: [ADMIN] question about HA in PG 9.0

y arrangements work in any time that isn't measure in large multiples of hours, so "10 seconds" I'm skeptical of. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, "PostgreSQL 9.

Re: [ADMIN] files under pg_clog directories are missing

partition. That can happen when a major disk-level problem occurs; system remounts as read-only because it doesn't think it can safely write to it anymore. I'd check into the system kernel logs as soon as possible, to try and find a disk error that kicked the whole thing off. --

Re: [ADMIN] files under pg_clog directories are missing

x27;t know why the crash happened, either. If you know for sure how it crashed, but only then found corruption, Scott's right that it's more likely to be a lying disk drive instead. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services a

Re: [ADMIN] files under pg_clog directories are missing

nd reload that before you start using it. You have no idea what state all of the tables are really in after a crash like this without such an exercise. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, &qu

Re: [ADMIN] question about HA in PG 9.0

If your storage is on EBS, I'm not sure how that handles two attempts to attach a writer to the store, but you'd want to test that out too. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, &quo

Re: [ADMIN] Ingres statdump equivalent for postgresql

nteractive/catalog-pg-statistic.html and to http://www.postgresql.org/docs/current/interactive/planner-stats-details.html for more details. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, "PostgreSQL 9.0 High Pe

Re: [ADMIN] issue with Postgres uninstallation

other than the main database sofware you can have installed will rely on those. Here's what I do to get rid of all the rest of them in one easy command: rpm -qa | egrep "^postgresql" | xargs rpm -e -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Tra

Re: [ADMIN] How To: LARGE html text or csv file COPY FROM?

rved characters that are input. -- Greg Smith, 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, "PostgreSQL 9.0 High Performance"Pre-ordering at: https://www.packtpub.com/postgresql-9-0-high-performance/book

Re: [ADMIN] General migration question

On Tue, Aug 31, 2010 at 9:07 AM, Alvaro Herrera wrote: > Excerpts from Greg Spiegelberg's message of mar ago 31 09:04:18 -0400 2010: >> Probably questions best asked on hackers but I figure many are represented >> here. >> Will there ever be a release where a dum

[ADMIN] General migration question

Probably questions best asked on hackers but I figure many are represented here. Will there ever be a release where a dump-restore is not necessary? Perhaps, at least, minor releases (e.g. 9.0 to 9.1) will not require a dump-restore? >From 9.0 Release Notes: E.1.2. Migration to Version 9.0 A dump

Re: [ADMIN] Is regular vacuuming with autovacuum needed?

working well than what I just described. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -- 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] The function of lock file named ".s.PGSQL..lock" on Linux?

wrote above) isn't mentioned. Seems like noting this file is created in the unix_socket_directory entry of the docs, and the rationale for why in the source code, would make a useful improvement. Anybody want to write a little documentation patch? -- Greg Smith 2ndQuadrant US Baltimore, MD

Re: [ADMIN] PostgreSQL on Solaris future

counted on packaged builds of PostgreSQL I'd be leaning how to do that myself fast--before they just remove resources related to it without warning anyone (again). -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -

Re: [ADMIN] How much RAM is too much ?

http://freebsdfoundation.blogspot.com/2010/06/dtrace-userland-project.html which will give me yet another reason to consider deploying on that OS instead of Linux. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.u

Re: [ADMIN] replication recommendation

ween slave updates, the table that holds queued changes on the master will get quite large, and the update will, naturally, take longer. Both are not too much of a concern, but if you have tables that change nearly all of their data between updates, you may want to switch to a different method a

Re: [ADMIN] Stumped by a version conflict.

e and therefore won't start with your current binaries. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to you

Re: [ADMIN] High Availability: Hot Standby vs. Warm Standby

ump even if log shipping is the main backup mechanism for a database, just so that corruption in the underlying files is caught as early as possible by trying to read every block and confirm it has valid data. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@

Re: [ADMIN] High Availability: Hot Standby vs. Warm Standby

ot depends on the value of your data and whether it can be retained at some higher level when this happens instead. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -- Sent via pgsql-admin mailing list (pgsql-admin

Re: [ADMIN] High Availability: Hot Standby vs. Warm Standby

be more fragile and buggy than just using 9.0--the bugs would be just be in your own code rather than in the core server. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -- Sent via pgsql-admin mailing list (pgsql

  1   2   3   >