Re: newbie needs help setting up pgsql on linux

Make sure you have installed the postgresql-server-x.x.x.i386.rpm

I recently ran into similar problems, my solution was to go right to the
website of the guy who packages the rpms: www.ramifordistat.net and
download the latest packages:

postgresql-6.5.3.i386.rpm
postgresql-server-6.5.3.i386.rpm
(I also downloaded test, devel, odbc, perl and python)

then I uninstalled everything that has anything to do with postgresql, then
installed these packages. Everything worked like a charm after that

Note: template1 ended up in /var/lib/pgsql/base

...hope this helps

Steve wrote in message <38613E63(dot)47B6BB22(at)ix(dot)netcom(dot)com>...
>There is a program called 'initdb' you need to run under your postgres
usercode.
>See 'man initdb' for details.
>
>Eldad Midan wrote:
>
>> Hi everybody,
>>
>> I am running RedHat Linux 6.1 on a Pentium, and am trying to migrate
existing
>> databases from Access-Win95 to PostgreSQL on Linux.
>>
>> I have installed the RPMs retrieved from RedHat's ftp site, read the
relevant
>> sections in the admin guide, the user's guide and some more, but I can't
get
>> postmaster to start. It seems that in order to start I need to install a
>> database with a template (template1) which should be in some ... .../data
>> directory. However, those files are nowhere to be found. I created a ...
>> ../data directory, ran initlocation -D
the-directory-where-the-data-will-reside
>> and postmaster claims not to find a file called ...
>> ../data/base/template1/pg_class. I looked around in various directories,
and
>> found some candidates in /usr/lib/pgsql/* but without instructions on how
to
>> make that into my template. Finally, when I 'touch' a file to be named
>> pg_class, postmaster complains that the file PG_VERSION does not exist.
>>
>> Can anyone help me?
>>
>> ari
>