Re: PostGreSQL - Accessing It

On 12/08/2003 23:51 Michael wrote:
> I installed RedHat 9.0 and found that PostGreSql was installed with the
> OS.  I started the service, tried to create a database.
>
> I cannot access/create a database from root or any of the other accounts
> I have setup for RH9.  I noticed that there is a user setup for postgres
> (I guess this part of the postgres install) but can't login as that
> user.  I can't even read or change the password.  How do I get at
> PostGreSql?

 From root, simply su postgres.

What I usually do then is use PostgreSQL's createuser command to create a
new super-user (i.e., one which can create new databases and new users).
On my developemt box, I make this the same as my login name. On production
boxes, we create a specific dba account an use that.

>
> Secondarily - does anyone know if JDBC drivers are part of the RH9
> PostGreSql install?

Yes but its in a separate RPM (on disk 2 IRC).
HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+