On (13/06/05 17:45), Redefined Horizons wrote: > I'm a little confused on this one. > > I chose to install PostgreSQL during the installation of Debian Sarge. > Both PostgreSQL and pgAccess were installed. > > However, when I try to create a new database using pgAccess, I get the > following error: > > "Tcl error executing > pg_exec create > database test > > is not a valid postgreSQL connection" > > Do I need to set up a PostgreSQL user before I can use pgAccess to > create a database? Do I need to do this from the command line? (I > didn't see a menu or command to do so in pgAccess.) I've used > PostgreSQL on Windows successfully, but I set up the users with the > Microsoft Installer for PostgreSQL, and I'm not sure how to accomplish > this on my Debian system.
Hi Scott IANE (I'm no expert) however, I recently set up postgresql. By default postgresql installs with 'postgres' as the only valid user initially. On the server you need to do: $ su (enter root passwd) # su postgres (no passwd required) $ createdb test $ psql test You are then in postgresql and you can create users etc. you will need to create yourself with CREATEDB privileges and possibly CREATEUSER privileges also. I recommend 'Postgresql Introduction and Concepts' by Bruce Momjian (available online): http://www.postgresql.org/files/documentation/books/aw_pgsql/ I also use 'Practical Postgresql' (O'Reilly) Have fun! Regards Clive -- www.clivemenzies.co.uk ... ...strategies for business -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
