Now what?

See the docs at www.postgresql.org/idocs/. More specifically,
www.postgresql.org/idocs/index.php?installation.html

Tim

----- Original Message -----
From: "Brian Kejser" <bkejser@KAISERDIGITAL.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, May 29, 2001 10:52 AM
Subject: [GENERAL] Now what?

Hi

I'm brand new to postgresql so I apologize if this sounds a bit stupid. I
just installed the lib and server RPMS for 7.1.1.4 on Redhat 6.2. Now

what?

I'm brand new to postgresql so I apologize if this sounds a bit stupid.

I

just installed the lib and server RPMS for 7.1.1.4 on Redhat 6.2. Now

what?

What do I have to do to connect to the database? How do I create my

first

procedure?

Just like with any other package, now you need to read the
documentation.

http://www.postgresql.org/users-lounge/index.html

steve

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 29 May 2001 13:52, Brian Kejser wrote:

Hi

I'm brand new to postgresql so I apologize if this sounds a bit stupid. I
just installed the lib and server RPMS for 7.1.1.4 on Redhat 6.2. Now what?
What do I have to do to connect to the database? How do I create my first
procedure?

Make sure you also installed the main rpm. IOW, you want to have installed:
postgresql
postgresql-libs
postgresql-server

Now, as root, execute
/etc/rc.d/init.d/postgresql start

This script will create the initial database structure and start postmaster.

Now, find the file README.rpm-dist, which, on RedHat 6.2 will be in
/usr/doc/postgresql-7.1.1

Read this file, along with the main documentation, in HTML browsable form, in
/usr/doc/postgresql-7.1.1/html -- the README.rpm-dist file will explain how
to make postmaster be started on every boot up.

Hope that helps!
- --
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7HUUr5kGGI8vV9eERAm4IAKCoYRfW0SG+06lOGa9vNHffu7x7RQCgsssh
r1X9XFvQktLcxFPga7BnUjE=
=YdkN
-----END PGP SIGNATURE-----

First, run the postmaster,

as root:
/sbin/service postgres start
(may be postgresql)

This should create an initial database.

Then, su to the user postgres and do
createuser YOURUSERNAME

and sign yourself up for all the priviledges.

Then, as yourself, do
createdb

That gives you a database with the same name as your username.

To connect to the database, just run
psql

and you're off and running!

johnnyb6@sdf.lonestar.org
SDF Public Access UNIX System - http://sdf.lonestar.org

On Tue, 29 May 2001, Brian Kejser wrote: