Re: [GENERAL] use window as field name in 8.4

On Tue, Jun 15, 2010 at 08:58:52AM -0600, Peter Lee wrote: > I am trying to upgrade our postgresql from 8.3 to 8.4. > > I found the "window" as field name makes many errors during > pg_restore. > > - like "item.window". > > Is there any way I can restore the dump file from 8.3 without > errors.

Re: [GENERAL] rename table and triggers

On Fri, Jun 18, 2010 at 1:41 PM, Michele Petrazzo - Unipex wrote: > now I just uncovered  a strange behavior from my point of view: I have a > table with a trigger associated with its insert. If I rename that table, the > trigger "follow" its parent. The trigger is connected to the table, not the

Re: [GENERAL] Unable to determine what has a particular OID

Greg Smith writes: > Andy Dale wrote: >> I will however save/backup the files before removing them (just in >> case anything goes wrong). > If you do go through with this, I would recommend doing a complete > database dump afterwards using pg_dump/pg_dumpall. That should make it > immediately

Re: [GENERAL] Unable to determine what has a particular OID

Andy Dale wrote: I will however save/backup the files before removing them (just in case anything goes wrong). If you do go through with this, I would recommend doing a complete database dump afterwards using pg_dump/pg_dumpall. That should make it immediately obvious if you broke something

[GENERAL] rename table and triggers

Hi list, now I just uncovered a strange behavior from my point of view: I have a table with a trigger associated with its insert. If I rename that table, the trigger "follow" its parent. Are this a wanted and the normal behavior? Are there somewhere a documentation about? Thanks, Michele --

[GENERAL] New COPY command (alternative to pg_loader) and Perl shell

I created a new shell-type utility for Pg that i think does some pretty interesting things: essentially it is like pg_loader, except it does not require any configuration files. Instead it relies on COPY and pseudo-COPY syntax. What it does is add two new "psedo-classes" of directives: `-PERL_key [

Re: [GENERAL] postgres crash SOS

Hi, This is my opinion, tell me if I am wrong. the backup runs at 00:30. At that time, i am sure nobody use the program which use postgres, so there is no transaction which store would be a problem when cobian creates the snapshot. Cobian started one day to create the backup but the volume was ful

Re: [GENERAL] Unable to determine what has a particular OID

On 18 June 2010 17:27, Tom Lane wrote: > Andy Dale writes: > > OK, I have just run the query, and both are in the same database. > > OK. Given the narrow range of timestamps on the files, the most > likely bet here is that you're looking at the leftovers from a > "CREATE TABLE AS" or similar co

Re: [GENERAL] Unable to determine what has a particular OID

Andy Dale writes: > OK, I have just run the query, and both are in the same database. OK. Given the narrow range of timestamps on the files, the most likely bet here is that you're looking at the leftovers from a "CREATE TABLE AS" or similar command that failed partway through and for some reaso

Re: [GENERAL] Unable to determine what has a particular OID

On 18 June 2010 17:00, Tom Lane wrote: > Andy Dale writes: > >> Try: > >> SELECT oid,* from pg_database ; > >> > >> I suspect the relfilnode you are looking at is another database in the > >> cluster. > > > Maybe I am possibly doing that. > > There isn't any "maybe" involved here. Follow Adrian

Re: [GENERAL] Unable to determine what has a particular OID

> To the best of my knowledge we have not had any DB crashes as yet. I am > also replicating the DB using slony, could this be the cause of these weird > orphans ? (it is neither of the sl_log_ tables) > Also looking at the timestamps of the files, they all seem to have been created within a very

Re: [GENERAL] Unable to determine what has a particular OID

Andy Dale writes: >> Try: >> SELECT oid,* from pg_database ; >> >> I suspect the relfilnode you are looking at is another database in the >> cluster. > Maybe I am possibly doing that. There isn't any "maybe" involved here. Follow Adrian's advice and determine for sure exactly which database th

Re: [GENERAL] Excessive Deadlocks On Concurrent Inserts to Shared Parent Row

On Thu, Jun 17, 2010 at 2:14 PM, Marvin S. Addison wrote: > My impression at present is that the fundamental locking behavior of > PostgreSQL is poorly suited to applications that have both great deals of > concurrency and referential integrity.  This is of concern to us as we are > considering mi

Re: [GENERAL] Unable to determine what has a particular OID

On 18 June 2010 16:37, Tom Lane wrote: > Andy Dale writes: > > On 18 June 2010 16:06, Tom Lane wrote: > >> You should be looking at pg_class.relfilenode, not OID. See > >> http://www.postgresql.org/docs/8.3/static/storage.html > > > Ok, but when I have dumped the pg_class table into a file lik

Re: [GENERAL] Unable to determine what has a particular OID

> > > > Try: > SELECT oid,* from pg_database ; > > I suspect the relfilnode you are looking at is another database in the > cluster. > > -- > Adrian Klaver > adrian.kla...@gmail.com > Maybe I am possibly doing that. I did a du -h --max-depth=1 in the base/ within the data directory. This showed

Re: [GENERAL] Unable to determine what has a particular OID

Andy Dale writes: > On 18 June 2010 16:06, Tom Lane wrote: >> You should be looking at pg_class.relfilenode, not OID. See >> http://www.postgresql.org/docs/8.3/static/storage.html > Ok, but when I have dumped the pg_class table into a file like so: > ... > Grep-ing for the correct oid/filenode

Re: [GENERAL] Unable to determine what has a particular OID

On Friday 18 June 2010 7:15:48 am Andy Dale wrote: > On 18 June 2010 16:06, Tom Lane wrote: > > Andy Dale writes: > > > After looking into the the data directory a particular file/oid is > > > around > > > > 21 > > > > > GB (the oid has 21 files), this OID can then be found in the pg_class > > >

Re: [GENERAL] Unable to determine what has a particular OID

On 18 June 2010 16:06, Tom Lane wrote: > Andy Dale writes: > > After looking into the the data directory a particular file/oid is around > 21 > > GB (the oid has 21 files), this OID can then be found in the pg_class > table, > > the explanation for the size being that the table has around 12.5 M

Re: [GENERAL] Unable to determine what has a particular OID

Andy Dale writes: > After looking into the the data directory a particular file/oid is around 21 > GB (the oid has 21 files), this OID can then be found in the pg_class table, > the explanation for the size being that the table has around 12.5 Million > rows. During the inspection of the data dir

Re: [GENERAL] postgres crash SOS

On Fri, Jun 18, 2010 at 4:55 AM, Felde Norbert wrote: > Hi, > > This are the informations I could collect: > > > We use cobian to create the backup. > There are two volumes in use, on C is the volume where everything is > installed and here is the postgres data dir too. > The postgres backup that

Re: [GENERAL] How to install 8.4 in Fedora 11 Leonidas

Try EntepriseDB one click installer. You can download it from http://www.enterprisedb.com/products/pgdownload.do. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company 2010/6/18 Andrus > I tried to install 8.4 in Fedora 11 using instruc

[GENERAL] Unable to determine what has a particular OID

Hi, We currently have a DB (8.3.7) in production that seem to be taking up more space on the HDD than was anticipated. After looking into the the data directory a particular file/oid is around 21 GB (the oid has 21 files), this OID can then be found in the pg_class table, the explanation for the

Re: [GENERAL] Backups / replication

Adrian von Bidder wrote: I don't know the rpm builds you're using; the Debian packages allow configuring two instances on two different ports AFAIK. Possibly the rpm installation do, too. Even if not: hacking up a 2nd start script which runs postgres against a different data directory / conf

Re: [GENERAL] How to install 8.4 in Fedora 11 Leonidas

You will need to bump up minor version number, since that package was updated. Alternatively, you can read this: http://people.planetpostgresql.org/devrim/index.php?/archives/43-How-to-install-PostgreSQL-9.0-Beta-1-to-FedoraCentOSRHEL.html This also applies to 8.4 . Regards, -- Devrim GÜNDÜ

[GENERAL] How to install 8.4 in Fedora 11 Leonidas

I tried to install 8.4 in Fedora 11 using instructions from http://www.if-not-true-then-false.com/2010/howto-install-postgresql-8-4-database-server-on-centos-fedora-red-hat rpm -Uvh http://yum.pgsqlrpms.org/reporpms/8.4/pgdg-fedora-8.4-1.noarch.rpm Retrieving http://yum.pgsqlrpms.org/reporpms/8

Re: [GENERAL] postgres crash SOS

Hi, This are the informations I could collect: We use cobian to create the backup. There are two volumes in use, on C is the volume where everything is installed and here is the postgres data dir too. The postgres backup that runs everynight places the backup file on this volume too, it runs bef