Answer to one : Postgres is the user account that the postgres DBMS in run as a service. You can create a user account for yourself from the command line using
createuser Synopsis createuser [options...] [username] Inputs -h, --host host Specifies the hostname of the machine on which the postmaster is running. If host begins with a slash, it is used as the directory for the unix domain socket. -p, --port port Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the postmaster is listening for connections. -e, --echo Echo the queries that createdb generates and sends to the backend. -q, --quiet Do not display a response. -d, --createdb Allows the new user to create databases. -D, --no-createdb Forbids the new user to create databases. -a, --adduser Allows the new user to create other users. -A, --no-adduser Forbids the new user to create other users. to use this created user to access the DB use : psql [ options ] [ dbname [ user ] ] you will be prompted for the user password (I think, I have not had to access the Db from the CLI since I put up my Zope front end application ;-) ) Answer to two : I installed and ran it from extensiont cd of LM 8.0 and it ran ok..... Answer to three : Check the Security Gurus -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Rodríguez Sent: Saturday, October 20, 2001 10:30 AM To: newbie Subject: [newbie] postgresql Getting started with PostgreSQL. I have never used a database program and know very little about this. I would like to install PostgreSQL on my 8.1 system, to begin learning how to work with it and develop a simple database. I have a number of questions as to how to get started. 1) Although PostgreSQL is not yet installed on my system, there is a user account that already seems to have been created on install by the name of "postgres". Currently it has no passwd, and is only accessible through root. Is this the user account I should use to work with PostgreSQL, is that what this is there for? 2) Would it be more beneficial for me at this moment in time to install PostgreSQL from the Mandrake cds, or attempt an install from source? 3) I do not want to open myself to security issues. My database is for internal use only. Will installing PostgreSQL start any servers or potentially compromisable services by default? If so, how can I turn these off, or should I? I know these are a lot of questions to dump on the group, this sort of stuff is even before what is covered in the tutorials. Thanks, everybody. -Paul Rodríguez _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com