Обсуждение: Trying to setup Postgres for the 1st time.

I installed Red Hat 6.0 (Mandrake 6.0) and chose to install the Postgres
package.

Apparently it isn't completely setup.  Are there any VERY EASY TO FOLLOW
instructions on configuring Postgres?  I read some docs that were suppose to
be about stetting this up but the guy went off on some tangent about
"parallel universes" and other very strange crap.  All I want is a step by
step instruction list.

Thanks.

I just set mine up try initdb. You should be logged in as Postgres first. This
will create the default database Template1.  I had a hard time logging in as
Postgres so I had to change the accounts password by using

> passwd postgres

hope this helps a little.

Suddn wrote:

> I installed Red Hat 6.0 (Mandrake 6.0) and chose to install the Postgres
> package.
>
> Apparently it isn't completely setup.  Are there any VERY EASY TO FOLLOW
> instructions on configuring Postgres?  I read some docs that were suppose to
> be about stetting this up but the guy went off on some tangent about
> "parallel universes" and other very strange crap.  All I want is a step by
> step instruction list.
>
> Thanks.

Suddn <Bogus@nospam.com> wrote:
> I installed Red Hat 6.0 (Mandrake 6.0) and chose to install the Postgres
> package.

> Apparently it isn't completely setup.  Are there any VERY EASY TO FOLLOW
> instructions on configuring Postgres?  I read some docs that were suppose to
> be about stetting this up but the guy went off on some tangent about
> "parallel universes" and other very strange crap.  All I want is a step by
> step instruction list.

> Thanks.

Suddn <Bogus@nospam.com> wrote:
> I installed Red Hat 6.0 (Mandrake 6.0) and chose to install the Postgres
> package.

> Apparently it isn't completely setup.  Are there any VERY EASY TO FOLLOW
> instructions on configuring Postgres?  I read some docs that were suppose to
> be about stetting this up but the guy went off on some tangent about
> "parallel universes" and other very strange crap.  All I want is a step by
> step instruction list.

> Thanks.

RedHat 6.0 does not finish the installation of Postgres. To
get it working after the installation, enter the following
commands as root:

  su postgres
  /usr/bin/initdb --pgdata=/var/lib/pgsql --pglib=/usr/lib/pgsql
  exit
  /etc/rc.d/init.d/postgres start

Suddn <Bogus@nospam.com> wrote:
> I installed Red Hat 6.0 (Mandrake 6.0) and chose to install the Postgres
> package.
> Apparently it isn't completely setup.  Are there any VERY EASY TO FOLLOW
> instructions on configuring Postgres?

On 12 Sep 1999 04:59:32 GMT, Steve OBrien
<sobrien@ego.jefferson.co.us> wrote:

>RedHat 6.0 does not finish the installation of Postgres. To
>get it working after the installation, enter the following
>commands as root:
>
>  su postgres
>  /usr/bin/initdb --pgdata=/var/lib/pgsql --pglib=/usr/lib/pgsql
>  exit
>  /etc/rc.d/init.d/postgres start

  I'll be blowing away my Redhat 5.1 and installing 6.0 later on
this week.  Any other gotcha's?

  I'm new to linux, but I have some programming experience
with Oracle SQL and PL/SQL.  Here are a few questions before
I dive in.

  My major goal is to connect with Oracle 8 at work.  Via a
modem at first, maybe on the LAN at work if I can do anything
spiffy with Postgresql <=> Oracle.

  My major complaint with Oracle's PL/SQL is that it has no
I/O options worthy of that name for the basic client.  You
can spool a raw SQL query of umpteen gigs.  But nothing under
PL/SQL's program control.  Oracle's half-assed compromise is a
1-meg memory buffer that can be dumped to disc when the program
finishes.  Forget about reading input files on the client.  Of
course, if you get an expensive developer package, there is a
"TEXT_IO" module.  Do the words "profit centre" sound familiar?

  Is there an option to use a direct programming tool like perl
or python or tcl with Postgresql?

  Is anybody familiar with the connecting Postgresql to Oracle?
I assume it would involve ODBC.  Would a Linux equivalent of
Oracle's SQLNet 8 (network transport over TCP/IP) be required?

--
Walter Dnes <waltdnes@interlog.com> procmail spamfilter
http://www.interlog.com/~waltdnes/spamdunk/spamdunk.htm

Walter Dnes wrote in message ...
>
>  I'll be blowing away my Redhat 5.1 and installing 6.0 later on
>this week.  Any other gotcha's?
>


    Yeah, get the latest sources and recompile.  The version that comes with
RH is quite old.  You'll want  the 6.5.1 release.  Or the 6.5.2 if it comes
out by then.

                            Damond

I re-read my recent post, and I noticed an error that I
made in my RedHat 6.0 instructions.  Please see the
corrected version below.  (I said to execute the postgres
command in the init.d directory when I meant to say postgresql)
thus:

  RedHat 6.0 does not finish the installation of Postgres. To
  get it working after the installation, enter the following
  commands as root:

    su postgres
    /usr/bin/initdb --pgdata=/var/lib/pgsql --pglib=/usr/lib/pgsql
    exit
    /etc/rc.d/init.d/postgresql start

Sorry if I messed anyone up.
Steve