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
