Is It Right To Copy /data from 8.4 to 9 Postgresql

Questions and answers regarding general SQL and backend databases

Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby cuoredisardegna » Wed Jan 02, 2013 10:21 pm

Hi to All,

could SomeOne correct eventual mistakes?

In order to transfer Postgres data from the Server Linux to a windows laptop two steps were made:

1) A tar.gz of the whole /data from Linux Server PostgreSQL 8.4
2) A copy of /data in Windows PostgreSQL 9.

The effect is that, if in Pgadmin the connection to the server is attempted, after the correct password type:
1) no connection is obtained ;
2) no error message is returned.

It was tryed to copy postgres.conf original(9) with no result.

The intention is of using in the windows laptop all data contained in Linux /data.

Tanks in advance.
Gianni Pinna.
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby Harjo » Wed Jan 02, 2013 10:56 pm

Hi,

here is a nice explanation from Robert: viewtopic.php?f=4&t=19133#p103192
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby cuoredisardegna » Wed Jan 02, 2013 11:20 pm

Hi Harjo,

it is a pleasure to read Your prompt replay.

Tank You very much.

Hope a Good 2013 for You in accord to Your more remote intentions, Harjo.
Best Rgrds.

Gianni Pinna.
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby Harjo » Wed Jan 02, 2013 11:50 pm

It's an explanation, Robert already posted to you.....
So I do not understand why your going a different road :?
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby cuoredisardegna » Wed Jan 02, 2013 11:52 pm

Hi Harjo,
after having answered To You I have read the Robert perfect link.
To well look the things, the solution that Robert gave to that problem of mine is the same for this problem.

Reading it seems that we despiced his solution and his gift.

But the true is that I have seen the two problems from two different points of view, without having thought and understood, as You have Harjo, about the relationship between the two.
Infact the first time the intention was to upgrade the Linux server from 8.4 to higher.

The second time, the intention was to transfer all data from the server 8.4 to laptop with 9.0, having I lost all data in laptop because hd died.

Hope I have clarified in respect of Your Persons and of Your work.

Tank You again.
Gianni Pinna.
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby Harjo » Thu Jan 03, 2013 12:24 am

Gianni, are you using some kind of Google translate? because it's hard to read what you mean. :wink:
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby cuoredisardegna » Thu Jan 03, 2013 7:23 am

Hi Harjo,
yes I used it.
But although it wos hard -I am exusing- has it been sufficient to clarify?

Tanks in advance.
Gianni Pinna.
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby ROCLASI » Thu Jan 03, 2013 7:34 am

Hi Gianni,

You can use pg_dumpall also for moving/copying your data to another machine. Just dump the data and move the sql file to the other machine and execute it via psql like I explained in my post.

Hope this helps.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Is It Right To Copy /data from 8.4 to 9 Postgresql

Postby cuoredisardegna » Thu Jan 03, 2013 8:39 am

Hi Robert,
this is the only way for this moment, in these circustances.
Hope a good day for You, Robert.

Many Tanks.
Gianni Pinna.
cuoredisardegna
 
Posts: 68
Joined: Mon May 07, 2012 5:34 am


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 5 guests