From owner-freebsd-database Thu Jan 18 7:23:51 2001 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (SHW2-220.accesscable.net [24.71.145.220]) by hub.freebsd.org (Postfix) with ESMTP id 1BBDE37B400 for ; Thu, 18 Jan 2001 07:23:32 -0800 (PST) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.11.1/8.11.1) with ESMTP id f0IFLOV01840; Thu, 18 Jan 2001 11:21:24 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Thu, 18 Jan 2001 11:21:24 -0400 (AST) From: The Hermit Hacker To: Francisco Reyes Cc: Subject: Re: Need help with PostgreSQL database In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Thu, 18 Jan 2001, Francisco Reyes wrote: > I installed PostgresSQL from ports. I am trying to access any database or > to create a new one, without much luck. > > I noticed the port made a user called pgsql. Am I supposed to use this? > I tried using that user by becoming root and then that user. Then I tried > psql. > > It complained about database "psql" not existing. If I try "psql test" it > gives me read access denied. do a 'psql template1' ... from there, you can do a 'create database' or 'create user' to build ... template1 is as it states ... the base database for the system, that all others are built from. If you create a table in template1, then do a 'create database', that new database you just created will also contain that table you created in template1, so, in general, avoid doing anything but creating users and databases from template1 ... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message