Thread: newbie needs help setting up pgsql on linux
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
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
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 >