Re: [ADMIN] unable to restore 8.2.5

2008-09-26 Thread Tore Halset
Hello. Thanks a lot! Using the script, I found the entries with invalid UTF-8 and fixed them in the database. - Tore. On Sep 19, 2008, at 15:37 , Mikel Lindsaar wrote: On Fri, Sep 19, 2008 at 6:29 PM, Tore Halset [EMAIL PROTECTED] wrote: Looks like I have managed to insert an illegal

[ADMIN]

2008-09-26 Thread Lennin Caro
--Original-- Hi Everybody, About 1.5 month ago, my machine (which runs redhat linux 2.6.9-78.0.1.ELsmp on Dell hardware with postgres 8.3.3) had a terrible crash. I am mostly recovered, but there is at least one more thing that's not

Re: [ADMIN]

2008-09-26 Thread Paul B. Anderson
If you are sure postgresql is not running based on the pid value, it could be refusing to start because the pid file is still there. Remove the pid file (in the data directory I think) and it should then start in the usual way. Lennin Caro wrote:

Re: [ADMIN] postgres at reboot

2008-09-26 Thread Tena Sakai
Hi Scott, When I issue: /sbin/chkconfig --list | grep postgres it comes back with: postgresql_ORG 0:off 1:off 2:off 3:off 4:off 5:off 6:off postgresql 0:off 1:off 2:on3:on4:on5:on6:off I felt a bit strange that it says 'off' at run level 6. I went into

Re: [ADMIN] postgres at reboot

2008-09-26 Thread Scott Marlowe
On Fri, Sep 26, 2008 at 2:38 PM, Tena Sakai [EMAIL PROTECTED] wrote: Hi Scott, When I issue: /sbin/chkconfig --list | grep postgres it comes back with: postgresql_ORG 0:off 1:off 2:off 3:off 4:off 5:off 6:off postgresql 0:off 1:off 2:on3:on4:on5:on

Re: [ADMIN] postgres at reboot

2008-09-26 Thread Tena Sakai
Hi Scott, It's too bad (in this particular case) that you are agreeing with me! I want someone to find a hole in my logic so that I can find a handle to fix the problem. The problem being that postgres doesn't get started when the machine gets rebooted. Regards, Tena Sakai [EMAIL PROTECTED]