Re: postgres database framework disappeared: Solved
Johann Spies <[EMAIL PROTECTED]> writes: > On Sat, Jun 03, 2000 at 12:05:45AM +0100, Oliver Elphick wrote: > > Johann Spies wrote: > > >On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > > >In /etc/passwd the line was > > >postgres:x:31:32:postgres:/var/lib/postgres:/bin/sh > > > > > >I removed the /lib part and then after a reboot it worked. > > > > > > > > >How /var/postgres became /var/lib/postgres I do not know. Earlier > > >today there was no problem and I did not edit that file for months. The version in potato changes the default postgres home directory from /var/postgres to /var/lib/postgres, so if you upgraded from slink to potato that might affect things. As I understand it, however, it doesn't touch /etc/passwd, but I could be mistaken. You might also take a look at /etc/postgresql/postmaster.init. The potato version points PGDATA and, by default, POSTGRES_HOME, to /var/lib/postgres/data and /var/lib/postgres/data respectively. I think the change is intended for FHS compliance. How that would affect things over the course of one day, I'm not sure, but clearly something must have changed during that day. --Miguel
Re: postgres database framework disappeared: Solved
On Sat, Jun 03, 2000 at 12:05:45AM +0100, Oliver Elphick wrote: > Johann Spies wrote: > >On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > > [snip] > >I found the culprit but still does not know how it happened: > > > >In /etc/passwd the line was > >postgres:x:31:32:postgres:/var/lib/postgres:/bin/sh > > > >I removed the /lib part and then after a reboot it worked. > > > > > >How /var/postgres became /var/lib/postgres I do not know. Earlier > >today there was no problem and I did not edit that file for months. > > Did you update base-passwd? No. How do I do that? Johann -- J.H. Spies, Hugenotestraat 29, Posbus 80, Franschhoek, 7690, South Africa Tel/Faks 021-876-2337 Sel/Cell 082 898 1528(Johann) 082 255 2388(Hester) "Jesus saith unto him, Thomas, because thou hast seen me, thou hast believed. Blessed are they that have not seen, and yet have believed." John 20:29
Re: postgres database framework disappeared: Solved
Johann Spies wrote: >On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > >> I don't know how this happened. Suddenly postgres's postmaster is not >> running and trying to make it run results in the following error >> message: >> >> There is no PostgreSQL database framework in /var/postgres/data. >> Run initdb as the postgres user to create it. > >I found the culprit but still does not know how it happened: > >In /etc/passwd the line was >postgres:x:31:32:postgres:/var/lib/postgres:/bin/sh > >I removed the /lib part and then after a reboot it worked. > > >How /var/postgres became /var/lib/postgres I do not know. Earlier >today there was no problem and I did not edit that file for months. Did you update base-passwd? -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "If any of you lack wisdom, let him ask of God, that giveth to all men liberally without finding fault, and it will be given to him." James 1:5
Re: postgres database framework disappeared: Solved
On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > I don't know how this happened. Suddenly postgres's postmaster is not > running and trying to make it run results in the following error > message: > > There is no PostgreSQL database framework in /var/postgres/data. > Run initdb as the postgres user to create it. I found the culprit but still does not know how it happened: In /etc/passwd the line was postgres:x:31:32:postgres:/var/lib/postgres:/bin/sh I removed the /lib part and then after a reboot it worked. How /var/postgres became /var/lib/postgres I do not know. Earlier today there was no problem and I did not edit that file for months. Johann -- J.H. Spies, Hugenotestraat 29, Posbus 80, Franschhoek, 7690, South Africa Tel/Faks 021-876-2337 Sel/Cell 082 898 1528(Johann) 082 255 2388(Hester) "If any of you lack wisdom, let him ask of God, that giveth to all men liberally without finding fault, and it will be given to him." James 1:5