Hi,
I had the version 7.1 of postgresql running fine on Redhat 7.1.
Before upgrading my OS to RedHat 9, I forgot saying pgdump_all
- is there a way now to read the files stored with version 7.1
by using 7.3.4 without having to uninstall 7.3.4 and reinstall
7.1 just to say this command ?
Thanx in advance for any help.
piyush.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org 2 1399
No.
You need to remove 7.3.4 (make sure you backup your data directory)
Install 7.1.3 from source.
Run pg_dumpall
Backup your data directory
Move your data directory
Remove 7.1.3
Install 7.3.4
Restore from the pg_dump you did.
Sincerely,
Joshua Drake
Piyush Agarwal wrote: Hi, I had the version 7.1 of postgresql running fine on Redhat 7.1. Before upgrading my OS to RedHat 9, I forgot saying pgdump_all - is there a way now to read the files stored with version 7.1 by using 7.3.4 without having to uninstall 7.3.4 and reinstall 7.1 just to say this command ?
Thanx in advance for any help.
piyush.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandpromp t.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Joshua D. Drake wrote: No. You need to remove 7.3.4 (make sure you backup your data directory) Install 7.1.3 from source. Run pg_dumpall Backup your data directory Move your data directory Remove 7.1.3 Install 7.3.4 Restore from the pg_dump you did.
I would rather recommend not deinstalling 7.3.4!
You can compile and install 7.1.3 into a temporary directory and
listening to a different port.
./configure --prefix=/usr/local/pg71_temp --with-pgport=5439
make
make install
Now you restore the old installations data directory into the directory
/usr/local/pg71_temp/data and start the 7.1.3 postmaster.
You now use the 7.3.4 pg_dumpall command to dump the contents
PGPORT=5439
export PGPORT
pg_dumpall >(wherever_you_ want_the_dumpfi le)
You can stop the 7.1.3 postmaster now and proceed with reloading the
dump into your 7.3.4 installation
unset PGPORT
psql <(that_darn_dum pfile)
Jan Sincerely,
Joshua Drake
Piyush Agarwal wrote:
Hi, I had the version 7.1 of postgresql running fine on Redhat 7.1. Before upgrading my OS to RedHat 9, I forgot saying pgdump_all - is there a way now to read the files stored with version 7.1 by using 7.3.4 without having to uninstall 7.3.4 and reinstall 7.1 just to say this command ?
Thanx in advance for any help.
piyush.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
#============== =============== =============== =============== ===========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#============== =============== =============== ====== Ja******@Yahoo. com #
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: S. Crespel |
last post by:
Hi,
Where can I find informations about consequences of upgrading from PHP
4.2.3 to 4.3 regarding existing PHP applications ?
I have lots of existing PHP (4.2.3) scripts, will everything still work
if I upgrade PHP to 4.3 ? What changes have to be done ?
(Solaris 8, Apache 1.3.28, Oracle 8.1.9.3)
|
by: bartolomesintes |
last post by:
Hi,
I have installed PHPHome 2.3.4 in Windows XP. This WAMP package
installs Apache 2.0.50 , PHP 5.0.0 and it works fine. The SQLite
installed version is 2.8.14 and I would like to upgrade to a later
version. Is it possible? Is the upgrading process explained somewhere?
Thanking you in advance,
Barto
|
by: Michael Foord |
last post by:
http://www.voidspace.org.uk/python/articles/upgrading_python.html
I've been looking at whether to upgrade immediately from Python 2.3 to
Python 2.4 or postpone it. This is my first `major version change`, so
I've come up against the usual windoze (tm) problem - upgrading python
breaks all my extension modules.
I've been looking into the issues, what modules do I use, can I
compile them myself ? etc... and the result is a brief article...
|
by: Jonathan Hilgeman |
last post by:
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.
What are the main advantages of upgrading to 4.0? Speed? Features? I can go
through the whole changelog if need be, but I'd prefer to hear what actual
users are reporting as far as...
|
by: wellington fan |
last post by:
Dear newsies,
My ISP has offered to upgrade my servers from 3.23 to 4.1.
I'm excited by the potential gains in performance, and the ability to
write subqueries, but am wary of any forward incompatibilities. I have
a mass of PHP code with MySQL throughout. I don't relish peeking into
every file and making a determination of 'it should work' by eyeballs
alone.
| |
by: Mike Owen |
last post by:
Hi,
I have just used the import Wizard to import a VS 2003 app to VS 2005.
I have a lot of work to do to enable it to compile successfully with all the
errors and warnings it gave me, but as a starting point the compiler can no
longer find the function as at the bottom of this posting, that was in the
Global.asax.vb file.
All the function does is give an easy / quick way of getting the application
|
by: Noesis Strategy |
last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles.
Recently, I have begun to design Access databases using an copy of Access
2002 from my previous laptop. It works fine, but I would like to have all
the office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003 files?
2) What are the major reasons for upgrading to 2002 ?
|
by: Aidan Tobin |
last post by:
Hi,
I have to upgrade a number of databases from Access 2.0, Access 97 and
Access 2000 to work in Office 2003. These databases contain a number
of Forms coded with VBA as well as a number of Queries/Macros.
The Microsoft web site says that Office 2003 will open databases
created in these versions.
However i have in the past upgraded databases from access 2.0 to 97
|
by: progTiger |
last post by:
The upgrade wizard just hangs on step 5 of 5 when it reaches "Upgrading
DataEnvironment..." I have let it sit for 3 hours and it does nothing. .Net
Studio is not frozen, but the process does nothing. How do I get past this??
Tiger
|
by: JimLad |
last post by:
Hi,
We have a major ASP app that we are in the process of upgrading to
ASP.NET 1.1 and probably on to ASP.NET 2.0 in the middle of next year.
(We will also be upgrading to SQL2K5 at the same time).
The current architecture is heavily based on the client side, both for
validation and data access. The asp page is returned and then data is
modified or selected using XMLHTTP objects embedded on the page, which
post or get to a data...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |