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"
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