Re: Upgrading PostgreSQL

Hi,

Would this be of any help ? It's on Trustix but should work fine on other
distros as well.


Take a dump from your databases:

pg_dumpall -c > local_for_74x_c

Shutdown postmaster:

kill -9 postmaster process number

Datadir out of the way:

mv /usr/share/pgdata /usr/share/pgdata_old

New datadir:

mkdir /usr/share/pgdata
 chown postgres /usr/share/pgdata

Previous install out of the way:

mv /usr/share/pgsql /usr/share/pgsql_old

Extract your new Pg:

gunzip postgresql-7.4.x.tar.gz
 tar -xf postgresql-7.4.x.tar

Configure, make and install, with --prefix=/path/ you can specify install
directory, ie. the -L swicth in initdb, default is /usr/local/pgsql/:

cd postgresql-7.4.x
 ./configure (--with-or-without-this-and-that)
 gmake
 gmake install

Initdb:

chown -R postgres /usr/local/pgsql/
 su postgres
 /usr/local/pgsql/bin/initdb -D /usr/share/pgdata -L /usr/local/pgsql/share

Edit and save /usr/share/pgdata/postgresql.conf. Find line

unix_socket_directory = ''

and change it to:

unix_socket_directory = '/var/run/postgresql'

Edit /usr/share/pgdata/pg_hba.conf

Add line(s) like this (at the bottom, where the actual configuration is):

host all postgres your ip-adress your ip-mask trust

e.g.

host all postgres 192.168.16.100 255.255.255.0 trust

Save the file.

Ok, let's start the server:

/usr/local/pgsql/bin/postmaster -D /usr/share/pgdata -B 256 -N 128 &

-B is for buffers, -N is for number of connections, you might want to add -i
for outside connections (edit pg_hba.conf accordingly)

Finally, read your dump file in:

psql -E template1 < local_for_74x_c


BR,

Aarni



On Wednesday 24 March 2004 10:35, you wrote:
> Hello, can anyone tell me the exact steps to upgrading from 7.4.1 to
> 7.4.2.
> I didn't upgrade PostgreSQL until now, but I need to do that now, so I
> don't want to brake something.
>
> Thanks.

--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com
Pääsintie 26 | 45100 Kouvola | FINLAND
www.kymi.com | cfm.kymi.com
aarni.ruuhimaki@kymi.com | info@kymi.com
+358-5-3755 035 | +358-50-4910 037
-------------------------------------------------
This is a bugfree broadcast to you from a linux system.