Date: Thu, 18 Jan 2001 11:21:24 -0400 (AST) From: The Hermit Hacker <scrappy@hub.org> To: Francisco Reyes <lists@reyes.somos.net> Cc: <freebsd-database@FreeBSD.ORG> Subject: Re: Need help with PostgreSQL database Message-ID: <Pine.BSF.4.31.0101181119570.745-100000@thelab.hub.org> In-Reply-To: <Pine.BSF.4.21.0101180103320.13287-100000@zoraida.reyes.somos.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.31.0101181119570.745-100000>