Re: newbie needs help setting up pgsql on linux - Mailing list pgsql-general

From Mike DeFehr
Subject Re: newbie needs help setting up pgsql on linux
Date
Msg-id cW9b4.5737$pP.95398@news1.rdc1.mb.home.com
Whole thread Raw
In response to newbie needs help setting up pgsql on linux  (Eldad Midan <af8@stern.nyu.edu>)
List pgsql-general
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.47B6BB22@ix.netcom.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
>



pgsql-general by date:

Previous
From: "Mike DeFehr"
Date:
Subject: Access 2000 with PostgreSQL driver?
Next
From: Rahul Ravindrudu
Date:
Subject: [GENERAL] REF function