Postgres Pro
Downloads
Home   >   mailing lists

Thread: Now what?

Now what?

From
Brian Kejser
Date:
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?

Thanks

Re: Now what?

From
"Steve Wolfe"
Date:
> 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

Re: Now what?

From
Jonathan Bartlett
Date:
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:

> 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?
>
> Thanks
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

Re: Now what?

From
"Tim Barnard"
Date:
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?
> What do I have to do to connect to the database? How do I create my first
> procedure?
>
> Thanks
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

Re: Now what?

From
Lamar Owen
Date:
-----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-----