Re: [BUGS] I can't start postgres anymore

2002-11-09 Thread Tom Lane
Fabien Fischer <[EMAIL PROTECTED]> writes: > DEBUG: database system was interrupted being in recovery at 2002-11-07 > 14:12:46 CET > This probably means that some data blocks are corrupted > and you will have to use the last backup for recovery. > DEBUG: invalid resource manager i

Re: [BUGS] pg_ctl is fragile

2002-11-09 Thread Peter Eisentraut
Neil Conway writes: > Tom Lane <[EMAIL PROTECTED]> writes: > > Doesn't seem like kill's exit code is going to tell you enough. > > If you got, say, "Permission denied" rather than "No such process", > > you shouldn't report that the postmaster isn't running. > > Ok, fair enough -- so is there any

[BUGS] copy works, \copy doesn't

2002-11-09 Thread Paul Buder
Sorry for the duplicate post. I forgot to mention this is with Postgresql 7.2.2. It seems the psql \copy command doesn't work properly when dealing with certain non-ascii characters (which ones I don't know). At any rate I took some binary data and escaped it like so with perl. $text=~s/\\/

[BUGS] I was wrong about Re: copy works, \copy doesn't (fwd)

2002-11-09 Thread Paul Buder
I wrote: > It seems the psql \copy command doesn't work properly when dealing > with certain non-ascii characters (which ones I don't know). At any rate > I took some binary data and escaped it like so with perl. I was wrong. I wasn't escaping things properly; in particular, ascii 0 needed to be