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

Classic Servoy
1

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.

2

Hi,

here is a nice explanation from Robert: viewtopic.php?f=4&t=19133#p103192

3

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.

4

It’s an explanation, Robert already posted to you…
So I do not understand why your going a different road :?

5

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.

6

Gianni, are you using some kind of Google translate? because it’s hard to read what you mean. :wink:

7

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.

8

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.

9

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

Many Tanks.
Gianni Pinna.