Hi, have you checked that the links in $PGDATA\pg_tblspc on the new drive are valid ? They possibly still point to the old drive. I guess you have to correct them per hand before starting the moved DB. regards, Marc Mamin ________________________________________ Von: pgsql-general-owner@xxxxxxxxxxxxxx [pgsql-general-owner@xxxxxxxxxxxxxx]" im Auftrag von "Daniel Begin [jfd553@xxxxxxxxxxx] Gesendet: Montag, 11. Mai 2015 17:30 An: 'Francisco Olarte' Cc: rod@xxxxxx; pgsql-general@xxxxxxxxxxxxxx Betreff: Re: Restarting DB after moving to another drive Francisco wrote: "How big/critical is your database?" How big? According to PgAdmin my personal database is about 2TB... How critical? Well, about a year of work!-) Francisco wrote: "just did a stop/cp/change pgdata /restart, I suppose windows must have comparable ways" This is what I have just tried when I got “Could not read symbolic link “pg_tblspc/100589”: Invalid argument” Considering both drives are identical, could an image backup have done the job properly instead of a plane copy? Daniel -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Francisco Olarte Sent: May-11-15 11:01 To: Daniel Begin Cc: rod@xxxxxx; pgsql-general@xxxxxxxxxxxxxx Subject: Re: Restarting DB after moving to another drive Hi Daniel. On Mon, May 11, 2015 at 4:42 PM, Daniel Begin <jfd553@xxxxxxxxxxx> wrote: > Just to make sure I understand properly... > When I installed Postgresql, I set $PGDATA to point on my old drive > and I must now move everything on the new one. > In order to move everything on the new drive I must create a > tablespace on the new drive and then explicitly define this tablespace > as the new location of... > - the postgres database > - my personal database > - pg_default > - pg_global > Anything I missed or put in the wrong sequence? I do not think it is that easy. You can move nearly everything, but it will be slow an you are not going to get rid of the old disk. One question, ¿ How big/critical is your database ? because all your problems can be solved with a dump/initdb/restore easily, and if you can leave it doing overnight it is th easier way. Also, I've moved directories across disks before, and it has worked, but I use linux which is much simpler, and just did an stop / cp / change pgdata / restart, I suppose windows must have comparable ways. Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
