Re: Use of Postgres in RH 7.2

["Daniel F. Montagnese" <dmontagnese mutoh com>]

sharsh goatelecom com wrote:

> Hello,
>   Can anyone please tell me how to connect to Postgres and use it to
> create any schema, tables etc. Also how to find out whether i have
> installed Postgres..I am not sure of this though i have done a full
> installation of RH 7.2.
>
> Help eagerly awaited!,
>
> Regards,
> Harshad
>
> _______________________________________________
> enigma-list mailing list
> enigma-list redhat com
> https://listman.redhat.com/mailman/listinfo/enigma-list

I just did it for the first time last night, but  am not quite an expert
yet.  As root, type 'initdb'.  Make sure there is a postgres user.  As
postgres, type 'pg_ctl -D /var//lib/pgsql/data -o "-i" '
to start the postmaster as a daemon on an iternet domain tcp socket.  As
postgres, type  'createdb db_name'.  To connect to the new data base
named 'db_name', type 'psql db_name'.
Type '\?' to see the psql commands.  Type '\h' to see the available sql
commands.