Installing PostgreSQL in a Linux Environment

Eyinagho Newton

28 Aug 2004 28 Aug '04

13:35

Hiya Dees, I've seen the intelligent contributions you've been making to this community, and would wish to ask for your assistance to solve this problem. I have, before now, been working in the windows environment. Recently however, i installed SUSE 8.0 in my desktop, and as one of the open source softwares in SUSE, also installed PostgreSQL. The problem is that i have been unable to get it properly installed. The manual i read says i should do carry out the following steps: 1) Create the postgre user, using the following command: $ su - -c " useradd postgres " This was successfully done. 2) Install the postgreSQL Source package. This i have done successfully from the SUSE package. 3) Configure Source Tree. This I am supposed to do using: $ ./configure However, this has refused to work as shown by the following response i got from the system: newton@linux:~> cd home newton@linux:~/home> cd bin newton@linux:~/home/bin> ./configure bash: ./configure: No such file or directory newton@linux:~/home/bin> su Password: linux:/home/newton/home/bin # ./configure bash: ./configure: No such file or directory linux:/home/newton/home/bin # ls . PG_VERSION global pg_hba.conf pg_xlog postmaster.opts .. base pg_clog pg_ident.conf postgresql.conf linux:/home/newton/home/bin # exit exit newton@linux:~/home/bin> ls PG_VERSION global pg_hba.conf pg_xlog postmaster.opts base pg_clog pg_ident.conf postgresql.conf newton@linux:~/home/bin> ./configure --help bash: ./configure: No such file or directory newton@linux:~/home/bin> What exactly haven't i done correctly? How do i go about configuring the Source Tree? Thanks Newton _______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

Show replies by date

George Stoianov

28 Aug 28 Aug

15:03

New subject: [SLE] Installing PostgreSQL in a Linux Environment

Hello, Try starting it through the System run level editor in Yast. It seems like you are not in the right directory to run the ./configure script. Good luck. George --- Eyinagho Newton a écrit :

...

Hiya Dees,

I've seen the intelligent contributions you've been making to this community, and would wish to ask for your assistance to solve this problem.

I have, before now, been working in the windows environment. Recently however, i installed SUSE 8.0 in my desktop, and as one of the open source softwares in SUSE, also installed PostgreSQL. The problem is that i have been unable to get it properly installed.

The manual i read says i should do carry out the following steps:

1) Create the postgre user, using the following command: $ su - -c " useradd postgres "

This was successfully done.

2) Install the postgreSQL Source package. This i have done successfully from the SUSE package.

3) Configure Source Tree. This I am supposed to do using: $ ./configure

However, this has refused to work as shown by the following response i got from the system:

newton@linux:~> cd home newton@linux:~/home> cd bin newton@linux:~/home/bin> ./configure bash: ./configure: No such file or directory newton@linux:~/home/bin> su Password: linux:/home/newton/home/bin # ./configure bash: ./configure: No such file or directory linux:/home/newton/home/bin # ls . PG_VERSION global pg_hba.conf pg_xlog postmaster.opts .. base pg_clog pg_ident.conf postgresql.conf linux:/home/newton/home/bin # exit exit newton@linux:~/home/bin> ls PG_VERSION global pg_hba.conf pg_xlog postmaster.opts base pg_clog pg_ident.conf postgresql.conf newton@linux:~/home/bin> ./configure --help bash: ./configure: No such file or directory newton@linux:~/home/bin>

What exactly haven't i done correctly? How do i go about configuring the Source Tree?

Thanks

Newton

_______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

Vous manquez despace pour stocker vos mails ? Yahoo! Mail vous offre GRATUITEMENT 100 Mo ! Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/ Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis. A télécharger gratuitement sur http://fr.messenger.yahoo.com

Eyinagho Newton

29 Aug 29 Aug

19:02

New subject: [SLE] Installing PostgreSQL in a Linux Environment

Hiya George, Just like you suggested, i've tried to start it thru the system run level editor. The status does show 'yes' when i started postgreSQL thru the run level editor, but i'm surprised it won't let me create a database still, even with that. There must be something i haven't done. Thanks, Newton --- George Stoianov wrote:

...

Hello,

Try starting it through the System run level editor in Yast.

It seems like you are not in the right directory to run the ./configure script.

Good luck. George

--- Eyinagho Newton a �crit :

...
Hiya Dees,

I've seen the intelligent contributions you've

...
making to this community, and would wish to ask for your assistance to solve this problem.

I have, before now, been working in the windows environment. Recently however, i installed SUSE 8.0 in my desktop, and as one of the open source softwares in SUSE, also installed PostgreSQL. The problem is

...
i have been unable to get it properly installed.

The manual i read says i should do carry out the following steps:

1) Create the postgre user, using the following command: $ su - -c " useradd postgres "

This was successfully done.

2) Install the postgreSQL Source package. This i have done successfully from the SUSE package.

3) Configure Source Tree. This I am supposed to do using: $ ./configure

However, this has refused to work as shown by

been that the

...
following response i got from the system:

newton@linux:~> cd home newton@linux:~/home> cd bin newton@linux:~/home/bin> ./configure bash: ./configure: No such file or directory newton@linux:~/home/bin> su Password: linux:/home/newton/home/bin # ./configure bash: ./configure: No such file or directory linux:/home/newton/home/bin # ls . PG_VERSION global pg_hba.conf

...
pg_xlog postmaster.opts .. base pg_clog pg_ident.conf

...
postgresql.conf linux:/home/newton/home/bin # exit exit newton@linux:~/home/bin> ls PG_VERSION global pg_hba.conf pg_xlog

...
postmaster.opts base pg_clog pg_ident.conf postgresql.conf newton@linux:~/home/bin> ./configure --help bash: ./configure: No such file or directory newton@linux:~/home/bin>

What exactly haven't i done correctly? How do i go about configuring the Source Tree?

Thanks

Newton

_______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

Vous manquez d�espace pour stocker vos mails ? Yahoo! Mail vous offre GRATUITEMENT 100 Mo ! Cr�ez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Le nouveau Yahoo! Messenger est arriv� ! D�couvrez toutes les nouveaut�s pour dialoguer instantan�ment avec vos amis. A t�l�charger gratuitement sur http://fr.messenger.yahoo.com

-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

__________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail

Jerome R. Westrick

28 Aug 28 Aug

15:14

New subject: [SLE] Installing PostgreSQL in a Linux Environment

On Sat, 2004-08-28 at 15:35, Eyinagho Newton wrote:

...

Hiya Dees,

I've seen the intelligent contributions you've been making to this community, and would wish to ask for your assistance to solve this problem.

I have, before now, been working in the windows environment. Recently however, i installed SUSE 8.0 in my desktop, and as one of the open source softwares in SUSE, also installed PostgreSQL. The problem is that i have been unable to get it properly installed.

The manual i read says i should do carry out the following steps:

SuSE has done modt of this automatically for you... Follow the intructions in /usr/share/doc/packages/postgres/README.SuSE There the nice people at SuSE have left notes about what they have done and what is remaining for you to do...

...

1) Create the postgre user, using the following command: $ su - -c " useradd postgres "

This was successfully done.

2) Install the postgreSQL Source package. This i have done successfully from the SUSE package.

3) Configure Source Tree. This I am supposed to do using: $ ./configure

However, this has refused to work as shown by the following response i got from the system:

newton@linux:~> cd home newton@linux:~/home> cd bin newton@linux:~/home/bin> ./configure bash: ./configure: No such file or directory newton@linux:~/home/bin> su Password: linux:/home/newton/home/bin # ./configure bash: ./configure: No such file or directory linux:/home/newton/home/bin # ls . PG_VERSION global pg_hba.conf pg_xlog postmaster.opts .. base pg_clog pg_ident.conf postgresql.conf linux:/home/newton/home/bin # exit exit newton@linux:~/home/bin> ls PG_VERSION global pg_hba.conf pg_xlog postmaster.opts base pg_clog pg_ident.conf postgresql.conf newton@linux:~/home/bin> ./configure --help bash: ./configure: No such file or directory newton@linux:~/home/bin>

What exactly haven't i done correctly? How do i go about configuring the Source Tree?

Thanks

Newton

_______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

Eyinagho Newton

29 Aug 29 Aug

18:48

New subject: [SLE] Installing PostgreSQL in a Linux Environment

Hiya Jerome, I have tried to do what you suggested, but the following was all i could get from the file. ........... The configuration variables for the PostgreSQL server are now stored in the /etc/sysconfig/postgresql file. Now, you can set many commando line parameters in /var/lib/pgsql/data/postgresql.conf. Before updating PostgreSQL packages whose version numbers are to increase by at least the second decimal place or higher (for example, 6.4.x to 7.0.x or 7.1.x to 7.2.x), use the pg_dumpall program to back up your PostgreSQL databases. A typical command for doing this is: pg_dumpall > SAVE Backups should be performed as user "postgres". Once the backup is completed successfully, shut down the PostgreSQL server (as root: "rcpostgresql stop"). Further configuration files in /var/lib/pgsql/data, including pg_hba.conf and postmaster.opts.default, may need to be backed up as well. Afterwards, delete the previous database files rm -r /var/lib/pgsql/data/* or, if you have enough space, move it to mv /var/lib/pgsql/data /var/lib/pgsql/data.old so that the new database structure can be created under /var/lib/pgsql/data when you start the new database server for the first time (as root:"rcpostgresql start"). The saved contents of the database and the configuration files will then have to be played back as user postgres: psql template1 -f SAVE If, following exhaustive testing, you are certain that everything is still available and functioning properly after the migration, delete the backup file and the old database files. Have a lot of fun... newton@linux:/usr/share/doc/packages/postgresql> ............ The manual above still hasn't told me how to configure the source tree, nor how to start PostgreSQL. I'm just 1 month new to databases, and the linux operating system, so please don't be angry that i still appear to be a mug. Thanks for your help. Yours, Newton --- "Jerome R. Westrick" wrote:

...

...
Hiya Dees,

I've seen the intelligent contributions you've been making to this community, and would wish to ask for your assistance to solve this problem.

I have, before now, been working in the windows environment. Recently however, i installed SUSE 8.0 in my desktop, and as one of the open source softwares in SUSE, also installed PostgreSQL. The problem is

On Sat, 2004-08-28 at 15:35, Eyinagho Newton wrote: that i

...
have been unable to get it properly installed.

The manual i read says i should do carry out the following steps:

SuSE has done modt of this automatically for you... Follow the intructions in /usr/share/doc/packages/postgres/README.SuSE There the nice people at SuSE have left notes about what they have done and what is remaining for you to do...

...
1) Create the postgre user, using the following command: $ su - -c " useradd postgres "

This was successfully done.

2) Install the postgreSQL Source package. This i have done successfully from the SUSE package.

3) Configure Source Tree. This I am supposed to do using: $ ./configure

However, this has refused to work as shown by the following response i got from the system:

newton@linux:~> cd home newton@linux:~/home> cd bin newton@linux:~/home/bin> ./configure bash: ./configure: No such file or directory newton@linux:~/home/bin> su Password: linux:/home/newton/home/bin # ./configure bash: ./configure: No such file or directory linux:/home/newton/home/bin # ls . PG_VERSION global pg_hba.conf

...
pg_xlog postmaster.opts .. base pg_clog pg_ident.conf

...
postgresql.conf linux:/home/newton/home/bin # exit exit newton@linux:~/home/bin> ls PG_VERSION global pg_hba.conf pg_xlog

...
postmaster.opts base pg_clog pg_ident.conf postgresql.conf newton@linux:~/home/bin> ./configure --help bash: ./configure: No such file or directory newton@linux:~/home/bin>

What exactly haven't i done correctly? How do i go about configuring the Source Tree?

Thanks

Newton

_______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

__________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail

Eyinagho Newton

18:50

New subject: [SLE] Installing PostgreSQL in a Linux Environment

...

...
Hiya Dees,

I've seen the intelligent contributions you've been making to this community, and would wish to ask for your assistance to solve this problem.

I have, before now, been working in the windows environment. Recently however, i installed SUSE 8.0 in my desktop, and as one of the open source softwares in SUSE, also installed PostgreSQL. The problem is

On Sat, 2004-08-28 at 15:35, Eyinagho Newton wrote: that i

...
have been unable to get it properly installed.

The manual i read says i should do carry out the following steps:

SuSE has done modt of this automatically for you... Follow the intructions in /usr/share/doc/packages/postgres/README.SuSE There the nice people at SuSE have left notes about what they have done and what is remaining for you to do...

...
1) Create the postgre user, using the following command: $ su - -c " useradd postgres "

This was successfully done.

2) Install the postgreSQL Source package. This i have done successfully from the SUSE package.

3) Configure Source Tree. This I am supposed to do using: $ ./configure

However, this has refused to work as shown by the following response i got from the system:

newton@linux:~> cd home newton@linux:~/home> cd bin newton@linux:~/home/bin> ./configure bash: ./configure: No such file or directory newton@linux:~/home/bin> su Password: linux:/home/newton/home/bin # ./configure bash: ./configure: No such file or directory linux:/home/newton/home/bin # ls . PG_VERSION global pg_hba.conf

...
pg_xlog postmaster.opts .. base pg_clog pg_ident.conf

...
postgresql.conf linux:/home/newton/home/bin # exit exit newton@linux:~/home/bin> ls PG_VERSION global pg_hba.conf pg_xlog

...
postmaster.opts base pg_clog pg_ident.conf postgresql.conf newton@linux:~/home/bin> ./configure --help bash: ./configure: No such file or directory newton@linux:~/home/bin>

What exactly haven't i done correctly? How do i go about configuring the Source Tree?

Thanks

Newton

_______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com

_______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

7189

Age (days ago)

7190

Last active (days ago)

List overview

Download

5 comments

3 participants

participants (3)

Eyinagho Newton
George Stoianov
Jerome R. Westrick