Package: postgresql-common
Version: 107
Severity: normal
-- System info --
Linux 2.6.32-trunk-686 #1 SMP Sun Jan 10 06:32:16 UTC 2010 i686 GNU/Linux
Debian: squeeze
postgresql-8.3_8.3.11-0lenny1_i386.deb
postgresql-8.4_8.4.4-1_i386.deb
-- .... --
I'm unable to upgrade to pg-8.4: pg_upgradecluster does not seem to work
and I cannot use a pg_dumpall file either because postgresql would
re-copy data on old data dir thus duplicating my database, as in fact
did happen.
Here follow a few commands with relative outcome:
(sh-4.1$ is a 'postgres' shell)
---------------
sh-4.1$ pg_upgradecluster 8.3 main
sh-4.1$ Error: could not get cluster default encoding
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sh-4.1$ pg_lsclusters
Version Cluster Port Status Owner Data directory /
Log file
8.3 main 5432 online postgres /var/lib/postgresql/8.3/main /
/var/log/postgresql/postgresql-8.3-main.log
8.4 main 5433 online postgres /var/lib/postgresql/8.4/main /
/var/log/postgresql/postgresql-8.4-main.log
sh-4.1$ psql -p 5432 -l
List of databases
Name | Owner | Encoding
-------------+----------+-----------
db1... | user | LATIN1
db2... | user | LATIN1
db3... | user | LATIN1
db4... | user | LATIN1
db5... | user | LATIN1
db6... | postgres | SQL_ASCII
db7... | user | LATIN1
postgres | postgres | LATIN1
template0 | postgres | LATIN1
template1 | postgres | LATIN1
(10 rows)
sh-4.1$ psql -p 5433 -l
List of databases
Name | Owner | Encoding
-----------+----------+----------
postgres | postgres | LATIN1
template0 | postgres | LATIN1
template1 | postgres | LATIN1
(3 rows)
(to avoid duplicating again my databases I stopped pg-8.3 and did:)
r...@d..# mv /var/lib/postgresql/8.3 /var/lib/postgresql/OLD8.3
sh-4.1$ psql -p 5432 -l
(but this escamotage didn't work!)
sh-4.1$ pg_lsclusters
Error: /var/lib/postgresql/8.3/main is not accessible; please fix \
the directory permissions (/var/lib/postgresql/8.3/ \
should be world readable)
Version Cluster Port Status Owner Data directory Log file
sh-4.1$ echo $PGDATA
/var/lib/postgresql/8.4/main/
sh-4.1$ psql -p 5433 -f db_all.out postgres
Error: /var/lib/postgresql/8.3/main is not accessible; please /
fix the directory permissions (/var/lib/postgresql/8.3/ \
should be world readable)
------------------
At this point the question is: how can I transfer all my 8.3 databases to the
new 8.4?
Thanks for your attention. Regards,
Ennio
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
Ricevo solo messaggi Content-Type: plain/text (no html o multipart). )=(
!!! --> e-mail a mio nome via OE (M$) sono false e infette <-- !!!
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
