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
-- .... --
Hi!
I made some progress concerning my previous post but am now getting a
new error and still no possibility to work with pg-8.4 version.
Here is what I did:
en...@deby:~$ su - postgres
Password:
postg...@deby:~$ pg_upgradecluster 8.3 main
Error: target cluster 8.4/main already exists
postg...@deby:~$ pg_dropcluster 8.4 main --stop
postg...@deby:~$ pg_upgradecluster 8.3 main
Creating new cluster (configuration: /etc/postgresql/8.4/main, data:
/var/lib/postgresql/8.4/main)...
Moving configuration file /var/lib/postgresql/8.4/main/postgresql.conf to
/etc/postgresql/8.4/main...
Moving configuration file /var/lib/postgresql/8.4/main/pg_hba.conf to
/etc/postgresql/8.4/main...
Moving configuration file /var/lib/postgresql/8.4/main/pg_ident.conf to
/etc/postgresql/8.4/main...
Configuring postgresql.conf to use port 5433...
Disabling connections to the old cluster during upgrade...
Error: could not rename pg_hba.conf
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
postg...@deby:~$ ls -l /etc/postgresql/8.4/main
total 27
-rw-r--r-- 1 postgres postgres 316 Jun 19 17:56 environment
-rw-r--r-- 1 postgres postgres 143 Jun 19 17:56 pg_ctl.conf
-rw-r----- 1 postgres postgres 3822 Jun 19 17:56 pg_hba.conf
-rw-r----- 1 postgres postgres 1631 Jun 19 17:56 pg_ident.conf
-rw-r--r-- 1 postgres postgres 16955 Jun 19 17:56 postgresql.conf
-rw-r--r-- 1 postgres postgres 378 Jun 19 17:56 start.conf
postg...@deby:~$ ls -l /var/lib/postgresql/8.4/main
total 12
drwx------ 5 postgres postgres 1024 Jun 19 17:56 base
drwx------ 2 postgres postgres 1024 Jun 19 17:56 global
drwx------ 2 postgres postgres 1024 Jun 19 17:55 pg_clog
drwx------ 4 postgres postgres 1024 Jun 19 17:55 pg_multixact
drwx------ 2 postgres postgres 1024 Jun 19 18:00 pg_stat_tmp
drwx------ 2 postgres postgres 1024 Jun 19 17:55 pg_subtrans
drwx------ 2 postgres postgres 1024 Jun 19 17:55 pg_tblspc
drwx------ 2 postgres postgres 1024 Jun 19 17:55 pg_twophase
-rw------- 1 postgres postgres 4 Jun 19 17:55 PG_VERSION
drwx------ 3 postgres postgres 1024 Jun 19 17:55 pg_xlog
-rw------- 1 postgres postgres 133 Jun 19 17:56 postmaster.opts
-rw------- 1 postgres postgres 55 Jun 19 17:56 postmaster.pid
lrwxrwxrwx 1 postgres postgres 36 Jun 19 17:56 server.crt ->
/etc/ssl/certs/ssl-cert-snakeoil.pem
lrwxrwxrwx 1 postgres postgres 38 Jun 19 17:56 server.key ->
/etc/ssl/private/ssl-cert-snakeoil.key
postg...@deby:~$ psql -p 5433 mydb
psql: FATAL: database "mydb" does not exist
postg...@deby:~$ psql -p 5433 postgres
Welcome to psql 8.3.11 (server 8.4.4), the PostgreSQL interactive terminal.
^^^^^^^^^^^^^^^^^^^^^^
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
WARNING: You are connected to a server with major version 8.4,
but your psql client is major version 8.3. Some backslash commands,
such as \d, might not work properly.
postgres=# \lt
List of databases
Name | Owner | Encoding
-----------+----------+----------
postgres | postgres | LATIN1
template0 | postgres | LATIN1
template1 | postgres | LATIN1
(3 rows)
\l: extra argument "t" ignored
postgres=#
At this point I searched for a psql 8.4 pkg:
You have searched for paths that end with psql in suite squeeze, all
sections, and all architectures. Found 3 results.
File
Packages
/usr/bin/psql
postgresql-client-common
/usr/lib/postgresql/8.4/bin/psql postgresql-client-8.4
/usr/share/doc/icinga-idoutils/examples/scripts/prepsql icinga-idoutils [not
kfreebsd-amd64, kfreebsd-i386]
but it seems I have the most recent version:
r...@deby:~# apt-get install postgresql-client-8.4
Reading package lists... Done
Building dependency tree
Reading state information... Done
postgresql-client-8.4 is already the newest version.
r...@deby:~# apt-get install postgresql-client-common -s
Reading package lists... Done
Building dependency tree
Reading state information... Done
postgresql-client-common is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
There seems to be no way to get out of the empasse because if I try to
restore the output of a pg_dumpall it wriiites the data in the old
(8.3/main) data dir ;-(
What can I do?
Thanks for your attention,
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
