Thread
-
Re: psql won't start
Thomas Good <tomg@q8.nrnet.org> — 2000-11-09T13:34:52Z
On Thu, 9 Nov 2000, Diego A. Puertas F. wrote: > I have compiled succesfully PostgreSQL 7.0.2, and I had ran psql at least > twice and built a database without problem. > > > Now psql is not starting and throws the following message: > > psql: FATAL 1: Database "postgres" does not exist in the system catalog. > > > So, what's going on? Diego, You are missing an argument: the database name... $ psql <dbname> For exam: $ psql template1 -------------------------------------------------------------------- SVCMC - Center for Behavioral Health -------------------------------------------------------------------- Thomas Good tomg@ { admin | q8 } .nrnet.org IS Coordinator / DBA Phone: 718-354-5528 Fax: 718-354-5056 -------------------------------------------------------------------- Powered by: PostgreSQL s l a c k w a r e FreeBSD: RDBMS |---------- linux The Power To Serve -------------------------------------------------------------------- -
psql won't start
Diego A. Puertas F. <dpuertas@uc.edu.ve> — 2000-11-09T13:41:44Z
I have compiled succesfully PostgreSQL 7.0.2, and I had ran psql at least twice and built a database without problem. Now psql is not starting and throws the following message: psql: FATAL 1: Database "postgres" does not exist in the system catalog. So, what's going on? Diego A. Puertas Fernández
-
Re: psql won't start
Gerhard Kroder <gerhard.kroder@de.ibm.com> — 2000-11-09T14:44:53Z
Thomas Good wrote: > > On Thu, 9 Nov 2000, Diego A. Puertas F. wrote: > > Now psql is not starting and throws the following message: > > > > psql: FATAL 1: Database "postgres" does not exist in the system catalog. > > > > > > So, what's going on? > > Diego, > > You are missing an argument: the database name... > > $ psql <dbname> > For exam: $ psql template1 hmm, IMHO not necessarily. At least here psql connects to a default database, which is template1 unless you set it otherwise.... My guess: there is no database at all, just the system. You need to initialize one first (initdb). On my Debian System it gets initialized when installing PostgreSQL from Debian Packages. -- Gerhard Kroder
-
Re: psql won't start
Thomas Good <tomg@q8.nrnet.org> — 2000-11-09T15:06:58Z
On Thu, 9 Nov 2000, Gerhard Kroder wrote: > > $ psql <dbname> > > For exam: $ psql template1 > > > hmm, IMHO not necessarily. At least here psql connects to a default > database, which is template1 unless you set it otherwise.... > > My guess: there is no database at all, just the system. You need to > initialize one first (initdb). On my Debian System it gets initialized > when installing PostgreSQL from Debian Packages. Hallo Gerhard, This is not the case on RedHat, Slackware, FreeBSD or UnixWare. Don't know about SuSe(?) On these systems psql needs an arg else it complains that the database 'tomg' does not exist. ;-) Ciao -------------------------------------------------------------------- SVCMC - Center for Behavioral Health -------------------------------------------------------------------- Thomas Good tomg@ { admin | q8 } .nrnet.org IS Coordinator / DBA Phone: 718-354-5528 Fax: 718-354-5056 -------------------------------------------------------------------- Powered by: PostgreSQL s l a c k w a r e FreeBSD: RDBMS |---------- linux The Power To Serve -------------------------------------------------------------------- -
Re: psql won't start
Diego A. Puertas F. <dpuertas@uc.edu.ve> — 2000-11-09T21:25:29Z
Thomas post did solve the problem, I think I'm still a little influenced by the mysql way :-) El 09/11/00, Diego A. Puertas F. escribió: > I have compiled succesfully PostgreSQL 7.0.2, and I had ran psql at least > twice and built a database without problem. > > > Now psql is not starting and throws the following message: > > psql: FATAL 1: Database "postgres" does not exist in the system catalog. > > > So, what's going on? > > > Diego A. Puertas Fernández >