Re: [GENERAL] Dump and restore problem

2008-06-21 Thread Martin
Most files systems allocate in 1k(1024) block(s) If the resource requests more.. the OS FS allocates one more 1024 block (thus the display of 2048 allocation..) hope this makes sense, Martin - Original Message - From: "Stuart Luppescu" <[EMAIL PROTECTED]> To: Sent: Saturday, June 21

Re: [GENERAL] Dump and restore problem

2008-06-21 Thread Stuart Luppescu
On 木, 2008-06-19 at 11:57 +0200, David wrote: > > pg_restore: [tar archiver] could not open TOC file for input: No > such > > file or directory > > It sounds like the tar file is no longer being created. > > Try manually running the commands, and verify that the dump, restore, > and rsync still w

Re: [GENERAL] function question

2008-06-21 Thread Decibel!
On Jun 21, 2008, at 8:06 AM, kevin kempter wrote: Hi LIst; Is there a way to print all the lines being executed for a function, like the equivelant of a psql -ef for an sql file ? No, but you could use a debugger on it if you're running a more recent version... -- Decibel!, aka Jim C. Nas

Re: [GENERAL] Abnormal termination of PostgreSQL

2008-06-21 Thread Tom Lane
Bill Thoen <[EMAIL PROTECTED]> writes: > Does anyone know what happened and how I can fix it? Well, you evidently hit a bug, but there's not nearly enough info here to guess whether the bug is in Postgres, PostGIS, GEOS, or GDAL, or perhaps in your custom build process for one of these. I'd sugge

[GENERAL] Abnormal termination of PostgreSQL

2008-06-21 Thread Bill Thoen
I recently installed Fedora Core 9 and included PostgreSQL, built form source. I also built PostGIS, GEOS and GDAL to work with it. I had no problems compiling and installing PostgreSQL, but I did have some problems building GEOS and GDAL, although I think I've resolved those (FC9 comes with gc

[GENERAL] partitioned table insert triggers

2008-06-21 Thread Reece Hart
I'm trying to create a date-partitioned version of the postgres_log table that is described here: http://www.postgresql.org/docs/current/static/runtime-config-logging.html In lieu of hardcoding the partition table names in the trigger, as shown in the table partitioning docs, I wanted to dynamica

Re: [GENERAL] System in Recovery Mode But No Activity

2008-06-21 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On Fri, Jun 20, 2008 at 7:56 PM, John Cheng <[EMAIL PROTECTED]> wrote: >> The state of the server when I sent this e-mail was that there were >> two remaining connections/postgres subprocesses. I used kill -9 to >> stop those two subprocesses. Then post

[GENERAL] function question

2008-06-21 Thread kevin kempter
Hi LIst; Is there a way to print all the lines being executed for a function, like the equivelant of a psql -ef for an sql file ? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/