Re: [GENERAL] Encoding Sort order

On 5/31/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: I understand that it is possible for tables from different databases that have the exact same data but different Encoding can sort rows in differet orders. Could this allow affect the order that triggers and rules are fired? This mi

[GENERAL] Triggers to allow user create table?

Had a question on best approach with some security issues around on the fly table creation by a user. I want to users to create dynamic tables from the application. This means that the user logged in should have create table privileges at the database level. Assuming this is a security risk for a

Re: [GENERAL] Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x

> We have Pg 8.0.x and Pg 8.2.x on 2 separate Linux servers. We have a perl > script (perl 5.8.7, DBI-1.48/DBD::Pg-1.49) that connects to each > database to > determine if there are active connections.with the following query. > SELECT count(*) from pg_stat_activity; > > The above query always ret

[GENERAL] Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x

Hello, We have Pg 8.0.x and Pg 8.2.x on 2 separate Linux servers. We have a perl script (perl 5.8.7, DBI-1.48/DBD::Pg-1.49) that connects to each database to determine if there are active connections.with the following query. SELECT count(*) from pg_stat_activity; The above query always returns

Re: [GENERAL] PostgreSQL upgrade server A -> server B

> Upgrading large postgres databases (100GB+) takes awfully long time > when doing dump/restore. I was wondering if this process can be > optimized by directly dumping to a new version of Pg database > directly on another server without having to dump to the filesystem > and then restore it. From

[GENERAL] PostgreSQL upgrade server A -> server B

Hello, Forgive me if this has been discussed before (or if it sounds absurd) Upgrading large postgres databases (100GB+) takes awfully long time when doing dump/restore. I was wondering if this process can be optimized by directly dumping to a new version of Pg database directly on another serve

[GENERAL] Status of Postgres 8.2.4 and pg_standby

Hello, What is the ETA of postgresql 6.2.4? Also, will pg_standby make it to 8.2.xbranch? Thanks!

Re: [GENERAL] programmatic way to fetch latest release for a given major.minor version

On 9 Apr 2007 14:47:20 -0700, Andrew Hammond < [EMAIL PROTECTED]> wrote: I'm writing a script that wants to know the latest release for a given major.minor version. Is there some better way than parsing http://www.postgresql.org/ftp/source/ or trying to connect to ftp (which is invariably timing

Re: [GENERAL] How to speedup CHECKPOINTs?

On 3/28/07, Joseph S wrote: Dmitry Koterov wrote: > And the general question - why SELECT queries slowdown during the > CHECKPOINT? I thought that Postgres is a version-based database and read > queries are never blocked... Because the disk is busy. Is your pg_xlog on a separate disk?

[GENERAL] Lifecycle of PostgreSQL releases

Hello, What is the lifecycle of a 8.0/8.1/8.2 releases? With 8.3 scheduled to be released in July, what will be the status of the 7.4.x branch? We are planning pg upgrades from 8.0.x/7.4.x to 6.2.x and were wondering if it's worth waiting for the 8.3 release. Thanks in advance!

[GENERAL] Upgrading Postgres large databases with blobs

Hello, For some reason, my first attempt to send this email to the list didn't get through We have several independent database servers with ~50GB+ databases running postgres 8.0.x. We are planning to upgrade these databases to postgres 8.2.xover the weekend We plan to use the following st

[GENERAL] Recommendations for postgres upgrade of database with lobs

Hello, We have several independent database servers with ~50GB+ databases running postgres 8.0.x. We are planning to upgrade these databases to postgres 8.2.xover the weekend We plan to use the following steps to upgrade each server, 1. Dump the 8.0.x database cluster using 8.2.x pg_dumpall % .

[GENERAL] Real world performance improvements in 8,2

Does anyone have benchmarks for performance gains by upgrading to 8.2.x from earlier postgres versions say 8.0.x/8.1.x? Thanks!

Re: [GENERAL] [HACKERS] urgent: upgraded to 8.2, getting kernel panics

On 2/23/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Merlin Moncure" <[EMAIL PROTECTED]> writes: > On friday we upgraded a critical backend server to postgresql 8.2 > running on fedora core 4. Umm ... why that particular choice of OS? Red Hat dropped update support for FC4 some time ago, and AFAIK

Re: [GENERAL] pg_dump: [tar archiver] write error appending to tar archive

On 2/21/07, MG <[EMAIL PROTECTED]> wrote: Where do I find the man page. Try 'man pg_dump' or browse www.postgresql.org for Documentation if you can't get to any, Google is your best friend. - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "MG" <[EMAIL PROTECTED]> Sent:

Re: [GENERAL] Write errors in postgres log

Hello Tom, Thanks for the response. My replies inline... On 2/18/07, Tom Lane <[EMAIL PROTECTED]> wrote: "CAJ CAJ" <[EMAIL PROTECTED]> writes: > We have 2 servers running postgres database 8.0.3 serving a web application. You do realize we are up to 8.0.12 in tha

[GENERAL] Write errors in postgres log

Hello, We have 2 servers running postgres database 8.0.3 serving a web application. Recently, we started having problems with the web application and diagnosis lead to the following errors repeated in the postgres log files on both the servers. == CONTEXT: