Re: [GENERAL] server closed the connection unexpectedly

2006-10-06 Thread Mark Greenbank
Hi Doug,Are there any pointers as to how to fix corrupted data? Is seems like that might be the problem as I'm seeing a zero-length read in the log file (see my previous email).Thanks again,Mark On 10/6/06, Douglas McNaught <[EMAIL PROTECTED]> wrote: "Mark Greenbank" <[EMAI

Re: [GENERAL] server closed the connection unexpectedly

2006-10-06 Thread Mark Greenbank
FATAL:  unsupported frontend protocol FATAL:  The database system is starting upLOG:  database system is readyThe worrying bit (at least to my uneducated eye) is the line: LOG:  ReadRecord: record with zero length at D/72C79AD4Thanks,MarkOn 10/6/06, Mark Greenbank <[EMAIL PROTECTED]> wrote: Hi Ric

Re: [GENERAL] server closed the connection unexpectedly

2006-10-06 Thread Mark Greenbank
mp/restore? The latter would be hard since pg_dump also fails on this same table and pg_dump doesn't seem to have an 'ignore table' option. MarkOn 10/6/06, Richard Huxton <dev@archonet.com> wrote: Mark Greenbank wrote:> # psql --version> psql (PostgreSQL) 7.3.2May I be the

[GENERAL] server closed the connection unexpectedly

2006-10-06 Thread Mark Greenbank
Hi,I get this error when accessing the postgresl database  -- any ideas? What should I look at? I can query all of the other tables in the database, just not the email_queue table. Weird! Thanks in advance, Mark# psql --versionpsql (PostgreSQL) 7.3.2 contains support for command-line editing # psq

[GENERAL] Solaris 10 SMF for Postgres?

2005-07-23 Thread Mark Greenbank
Hi, Does anyone have a Solaris 10 SMF script for managing a postgres install? Mark ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Solaris 10 svc setup

2005-03-29 Thread Mark Greenbank
Hi, Does anyone have a Solaris 10 smf script that they'd like to share for controlling postgreSQL startup, shutdown, etc.? Mark ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister Your

[GENERAL] dblinks?

2005-03-27 Thread Mark Greenbank
Hi, I'm interested in deploying PostgreSQL in a production application but I'd like to know if the following features are available: - dblinks - partition tables If they are not, are they planned for a (near) future release? Thanks, Mark ---(end of broadcast)