Re: [GENERAL] pg_dump and write locks

ve test running, everything is in order, just slow. Thanks for your response, and apologies for the noise. - DAP -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 19, 2005 10:45 AM To: David Parker Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg

[GENERAL] pg_dump and write locks

contention, but I don't understand why COPY is locking at that level. Is there a better way to run pg_dump against a database with a lot of update activity?   Thanks.   - DAP ====== David Parker    Tazz Networks  

Re: [GENERAL] startup time

Does pg_ctl status return true even if the database is not ready yet to receive requests? We are using pg_ctl status to tell us if the database is up, but I'm wondering if it could return true, but a client could connect and still get the "FATAL: database is starting up" error?

Re: [GENERAL] dump/restore bytea fields

nks! - DAP------David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] dump/restore bytea fields

\\001\\001\\..."pg_restore: [archiver (db)] error returned by PQendcopy What am I missing?   Thanks! - DAP----------David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] startup time

>> The problem we are having is that in a customer installation, the >> startup on the database is taking significantly longer than we have >> ever seen it take before. > >Are we talking seconds, minutes, hours, days? It's in the seconds range, I think, probably not more than a minute, but I don

[GENERAL] startup time

up window, it would give me a starting point for asking questions of our field people about the installation environment.   Thanks. - DAP------David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] index xyz is not a btree

No, I haven't tried that - I wasn't aware of pg_filedump. What's tricky is that when the build detects a failure, it deletes the output directory (so we don't get left with a half-built db) so I'll have to fiddle with it I just downloaded pg_filedump from the redhat site, so I'll play around w

[GENERAL] index xyz is not a btree

debugging I can turn on would be appreciated. Thanks! - DAP------David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] SQL call to get pid of current connection

That certainly looks like it! Thanks! - DAP >-Original Message- >From: Michael Fuhr [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 02, 2005 8:47 PM >To: Bruno Wolff III; David Parker; postgres general >Subject: Re: [GENERAL] SQL call to get pid of current connection &g

Re: [GENERAL] SQL call to get pid of current connection

Yeah, simple enough. I just wanted to make sure I wasn't duplicating something that was already there. Thanks. - DAP >-Original Message- >From: Bruno Wolff III [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 02, 2005 6:02 PM >To: David Parker >Cc: postgres gener

[GENERAL] SQL call to get pid of current connection

Is there a function call that will return the pid of the postgres process associated with the current client connection? - DAP--David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] another failover testing question

I know better what is happening now. I had the scenario slightly wrong. Slony creates a trigger on all replicated tables that calls into a shared library. The _Slony_I_logTrigger method in this library establishes a saved plan for inserts into its transaction log table sl_log_1. I can create the m

Re: [GENERAL] another failover testing question

>It should not be ... at least, assuming that Slony is using >the standard DROP TRIGGER operation, rather than playing >directly with the system catalogs ... AFAICS, the slony uninstall command is not doing anything exotic, though it DOES do a little bit of fiddling with pg_catalog to RESTORE pr

Re: [GENERAL] another failover testing question

indeed not be an issue in 7.4.5, I will try to come up with a test case independent of a slony install. Thanks. - DAP >-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 26, 2005 4:30 PM >To: David Parker >Cc: postgres general >Subject: Re:

[GENERAL] another failover testing question

ony list because it seems like a general question)   Thanks. - DAP------David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] pg_listener records

- DAP >-Original Message- >From: Scott Marlowe [mailto:[EMAIL PROTECTED] >Sent: Thursday, May 26, 2005 2:51 PM >To: David Parker >Cc: postgres general >Subject: Re: [GENERAL] pg_listener records > >On Thu, 2005-05-26 at 13:41, David Parker wrote: >> In

[GENERAL] pg_listener records

od idea? - DAP----------David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] ceci n'est pas un btree

n use to get the search to work for only that whole phrase (I realize this is probably basic google stuff, but I was born before the web)   Thanks. - DAP----------David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] explicit cursor vs. for loop in pl/pgsql

Thanks for the info. I've got an index, so I guess it's as good as it gets! The data is actually copied over from the slony transaction log table, and there's no way to know how many statements (=rows) there might be for any given transaction, so assigning an arbitrary limit seems too risky, and I

[GENERAL] explicit cursor vs. for loop in pl/pgsql

the table gets huge.   Any suggestions appreciated! - DAP----------David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] rollback vs. commit for closing read-only transaction

--David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] debug levels in server

  I have log_min_messages = DEBUG5, and I'm seeing a lot of logging, but I don't see the create trigger statements showing up in the log. What do I need to set to get this output? Thanks. - DAP------David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] client interfaces

assume the answer to this is "no", and I see no hint of anything in the source code, but I thought I would ask the question, just to be sure.   Thanks. - DAP----------David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] WAL on a RAM disk

stand this parameter?)   3) Any other settings I should be looking at?   Thanks. I don't know if anybody else has done this, but I'd be interested to hear about it, if so. - DAP----------David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] monitoring database activity on solaris

OK, thanks. We're using pg_ctl to start it at the moment, but we can obviously change that. - DAP >-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 06, 2005 6:18 PM >To: David Parker >Cc: postgres general >Subject: Re: [GENER

[GENERAL] monitoring database activity on solaris

y would help a great deal! I'd be grateful to anybody running Solaris for any advice.   Thanks. - DAP------David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] limited disk space

trolling disk usage that somebody could point me to?   Thanks. - DAP----------David Parker    Tazz Networks    (401) 709-5130   

Re: [GENERAL] create or replace trigger?

f checking if the trigger existed already (I had CREAT OR REPLACE on the trigger function). But that's certainly not a hardship, and probably more "correct", anyway! Thanks. - DAP >-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Sunday, March

[GENERAL] create or replace trigger?

Is there a technical reason that the "or replace" syntax isn't supported for CREATE TRIGGER? - DAP----------David Parker    Tazz Networks    (401) 709-5130   

[GENERAL] error codes in log file?

--David Parker    Tazz Networks    (401) 709-5130   

Re: [Slony1-general] Re: [GENERAL] Slony uninstall info/warning

We recently ran into this as well, because in testing we had people leaving an application running against the database while they uninstalled slony. I'm curious, what OIDs would be missing exactly, since the application does not refer directly to any slony objects? Does the cached plan "know" abo

Re: [GENERAL] file descriptors

n able to repro this on my own yet. Thanks. - DAP >-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Friday, February 11, 2005 6:40 PM >To: David Parker >Cc: pgsql-general@postgresql.org >Subject: Re: [GENERAL] file descriptors > >"Davi

Re: [GENERAL] file descriptors

set to 8480 for the database owner on this system (not sure where that number came from). Thanks. - DAP >-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: Friday, February 11, 2005 6:17 PM >To: David Parker >Cc: pgsql-general@postgresql.org >Subjec

[GENERAL] file descriptors

t how many data files exist on the server, and/or an estimate for how many of them would have to be open at any given time? Do ALL of the data files get kept open, or do they get opened and closed? Thanks. - DAP--------

[GENERAL] logging

take effect? - DAP ---------- David ParkerTazz Networks(401) 709-5130   ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] checkpoints

or what this value should be? (we are at the default right now) 2) should checkpoint_timeout be changed at the same time? 3) should I increase wal_buffers in conjunction with checkpoint_segments? Thanks! - DAP ------ Da

Re: [GENERAL] disabling constraints

but maybe it wouldn't be too difficult... - DAP >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Vivek Khera >Sent: Thursday, November 04, 2004 3:05 PM >To: [EMAIL PROTECTED] >Subject: Re: [GENERAL] disabling constraints > >

[GENERAL] disabling constraints

standard" way of doing this? - DAP ---------- David ParkerTazz Networks(401) 709-5130   ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[GENERAL] process hang during drop schema

witch I should be setting? TIA for any suggestions. - DAP ---------- David ParkerTazz Networks(401) 709-5130   ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] external function libraries on non-build machine

les to get them installable in the new environment? I've tried setting the "AS $libdir/xxid' clauses to various strings with full paths, but I don't seem to be getting it. Thank you for any help. Apologies for the cross-post. - DAP =

[GENERAL] mirroring/replication

Is anybody using contrib/dbmirror in a production environment? - DAP == David ParkerTazz Networks(401) 709-5130 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to

[GENERAL] To OID or not to OID

ied that I'm missing something. - DAP ====== David ParkerTazz Networks(401) 709-5130 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

[GENERAL] trash talk

ot;dead" database! ;-) - DAP ====== David ParkerTazz Networks(401) 709-5130 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] installation problem...

There should be a config.log file in the directory where you ran configure: output in that file around the error is the first place to look. - DAP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Wynett Sent: Friday, July 23, 2004 5:37 PM To: '[E

[GENERAL] estimating table size

age overhead is what I'm wondering about, I guess. Thanks. - DAP ====== David ParkerTazz Networks(401) 709-5130 ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [GENERAL] moving an installation

CTED] Sent: Thursday, July 15, 2004 5:33 PM To: David Parker; [EMAIL PROTECTED] Subject: Re: [GENERAL] moving an installation David Parker wrote: > I need to be able to build postgres (7.4.3) with a given --prefix, but > then pack up the installation directory and deploy it in anothe

Re: [GENERAL] moving an installation

script? e.g., an environment variable or something? (setting the "libdir" env var doesn't seem to do it). Thanks. - DAP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Parker Sent: Thursday, July 15, 2004 4:05 PM To: [EMAIL PRO

Re: [GENERAL] SELECT based on function result

Did you try creating a view with that select statement, then just selecting from the view? I don't know if there is a restriction on using a function like that in a view definition or not. -DAP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Fitzp

[GENERAL] moving an installation

ime? I was under the impression that --disable-rpath prevented library paths from being compiled into the code, but maybe this "$libdir" is a different thing? Thanks in advance for any help. - DAP ====== David ParkerT

Re: [GENERAL] building 7.4.3 on Solaris 9/Intel

Thanks! -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 11:49 PM To: David Parker Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] building 7.4.3 on Solaris 9/Intel OK, I have fixed this so the configure test happens with the proper thread