problem with postgresql-dump while upgrading to 7.4 format

Oleg

Dear All,
I have upgraded Postgresql from 7.3 to 7.4.
Starting pg brings error:
The database is in an older format that cannot be read by version 7.4 of
PostgreSQL

dpkg-upgrade postgresql fails
I tried postgresql-dump. While dumping it brings the following error:
FATAL: unsupported frontend protocol
However the dump file is generated.
Does this error means that dump file can not be used or it can be ignored?
Thanks a lot
Oleg
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1

Subscribe Reply

1802

Oliver Elphick

On Fri, 2004-08-20 at 16:46, Oleg wrote:

Dear All,
I have upgraded Postgresql from 7.3 to 7.4.
Starting pg brings error:
The database is in an older format that cannot be read by version 7.4 of
PostgreSQL

dpkg-upgrade postgresql fails
I tried postgresql-dump. While dumping it brings the following error:
FATAL: unsupported frontend protocol
However the dump file is generated.
Does this error means that dump file can not be used or it can be ignored?

You seem to be using Debian. The whole process of upgrading between
major versions is fraught with problems, and 7.3 -> 7.4 is not well
tested, since 7.3 has never been part of Debian stable.

In /var/lib/postgres (or wherever else you may have directed that the
database be kept) there should be directories data, dumpall* and
preserve and (I think) a file called db.out.

..../preserve should contain the 7.3 database; .../data should contain
the new database, but apparnetly doesn't; db.out ought to be the dump as
a text file. Take a look at the dump file, if it is there. Does it
look complete?

--
Oliver Elphick ol**@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
=============== =============== ==========
"But I would not have you to be ignorant, brethren,
concerning them which are asleep, that ye sorrow not,
even as others which have no hope. For if we believe
that Jesus died and rose again, even so them also
which sleep in Jesus will God bring with him."
I Thessalonians 4:13,14
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2

Oleg

On Fri, 2004-08-20 at 16:46, Oleg wrote:

Dear All,
I have upgraded Postgresql from 7.3 to 7.4.
Starting pg brings error:
The database is in an older format that cannot be read by version 7.4 of
PostgreSQL

dpkg-upgrade postgresql fails
I tried postgresql-dump. While dumping it brings the following error:
FATAL: unsupported frontend protocol
However the dump file is generated.
Does this error means that dump file can not be used or it can be ignored?

You seem to be using Debian. The whole process of upgrading between
major versions is fraught with problems, and 7.3 -> 7.4 is not well
tested, since 7.3 has never been part of Debian stable.

In /var/lib/postgres (or wherever else you may have directed that the
database be kept) there should be directories data, dumpall* and
preserve and (I think) a file called db.out.

.../preserve should contain the 7.3 database; .../data should contain
the new database, but apparnetly doesn't; db.out ought to be the dump as
a text file. Take a look at the dump file, if it is there. Does it
look complete?

Thank you very much for your ahswer.
I have created db.out using
postgresql-dump -t db.out -dcivlp $PGDATA/../data.save
However postgresql-dump quit with message initdb: failed
I run initdb manualy and it worked ok
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

Similar topics

3525

library version problem, 7.3.2, php, redhat linux

by: Richard Welty | last post by:

ok, i'm confused. i have two systems. one is redhat 7.1 (a server in colo, reasonably current), the other is 8.0 (my laptop). the server in colo is running postgresql 7.3.2 along with redhat's updated versions of apache and php for 7.1 (the php version is 4.1.2) on this server, php can access postgres without difficulty. my laptop is...

PostgreSQL Database

1541

[Cygwin] Postgresql 7.3.4 Installation Problem

by: NK | last post by:

Trying to install Postgresql 7.3.4 using the Cygwin(the last version) , I followed all the instructions. After typing the "" ./configure "" command, I typed "" make "" (i have installed the GNU make 8 ) but after the build-process the result was not "All of Postgresql is successfully made,Ready to install" but the report of two errors ...

PostgreSQL Database

4485

JDBC DatabaseMetaData problem

by: Aleksey | last post by:

Hello, I have the following problem working with DatabaseMetaData. There is a database with table and attribute names in Russian. Database cluster was initialized with appropriate ru_RU.KOI8-R locale. All the databases were created with KOI8-R encoding. No problems were encountered in accessing database table data with JDBC.

PostgreSQL Database

8223

How to obtain the real problem that avoids postgresql service starting?

by: Netto | last post by:

Hi all,... I'd like to know where can I get information about what is happening to postgresql so it can't be started... all I get is: Starting postgresql service: Is there any log file, or a way to start the database with a kind of -v (verbose) option?? Or maybe any configuration parameter to modify on...

PostgreSQL Database

1485

Postgresql 7.4.1 Compile problem for SCO 5.0.5

by: Jeffrey Pogodzinski | last post by:

I am trying to compile postgresql 7.4.1 for sco 5.0.5 and get the following error: "thread.c", line 269: error: undefined symbol: h_errno Any ideas? ../configure --with-libs=/usr/local/lib --with-includes=/usr/local/include herbie!/tmp/postgresql-7.4.1 # gmake gmake -C doc all

PostgreSQL Database

5384

BLOB problem

by: Rens Admiraal | last post by:

Hi, I've encountered a problem with a PostgreSQL database. I made a image management system which stores images in a database from a PHP script. I upload te file using pg_lo_import() (PHP function). Everything works fine, fast, and I was really glad with it, till I found out that my database is rapadly growing. With only 20 images the...

PostgreSQL Database

1336

JDBC problem

by: Reynir Þór Hübner | last post by:

I'm running an engine with 15 databases, with fair amount of load. Every 4-5 days I'm getting error like this from the java side and the application stops working (and wont come back unless I restart) : java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(Native Method) at...

PostgreSQL Database

1575

Performance problem on RH7.1

by: Együd Csaba | last post by:

Hi All, I've a problem with the perfprmance of the production environment. I've two db servers. One on my laptop computer (2Ghz, 1GB, WinXP, Cygwin, Postgres 7.3.4) and one on a production server (2GHz, 1GB, Ultra SCSI, RH7.1, Postgres 7.3.2). I run the same dump and the same query on both of the computers. The difference is substantial....

PostgreSQL Database

5319

Postmaster Problem

by: Tony O'Bryan | last post by:

I am normally the admin for our PostgreSQL servers, but someone else tried to kill a runaway query while I was out sick. Unfortunately, he tried killing the runaway query by killing the postmaster. Now we are dealing with a persistent problem that just won't go away. 1) Spontaneous back end deaths. 2) Spontaneous backend disconnects...

PostgreSQL Database

2646

Postgresql Reinstallation problem on Windows

by: vkpradeep | last post by:

Hi I am trying to reinstall postgresql on windows.During the installtion it is showing the following error. The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory C:/Program...

PostgreSQL Database

7666

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7888

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7644

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

7951

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6260

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5484

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3643

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3626

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

925

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General