Moving Database Cluster to another drive

From: Daniel Begin <jfd553(at)hotmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Moving Database Cluster to another drive
Date: 2015-05-16 17:39:26
Message-ID: COL129-DS26D0CED8212C1AD76EFDEF94C60@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all, first some context.

I've had a tread about this topic on pgsql-general(at)postgresql(dot)org mailing
list (Restarting DB after moving to another drive). I had a lot of help to
learn how these things should be done from pgsql general list. However, at
this point, I feel I should continue the tread on the novice list because my
questions are getting more basic about PostgreSQL and databases.

I have a large PostgreSQL database (2TB) on my PC (Windows). Few weeks ago,
the drive dedicated to pgsql started overheating and I decided to move the
DB on a new drive. Considering my particular context and the time it was
going to take to restore from pg_dumpall output, I decided to copy the
content of the old drive to the new one and make things transparent to
PostgreSQL - if possible.

As expected, I was able to copy the database cluster on the new drive during
the night. I changed the drive letter to fit the original database drive and
I restarted the DB. Since then, everything seems running on the new drive as
it used to be with the old one, with a small exception...

The time expected to run queries on some tables seems longer. My questions
are .

- How indexes are actually implemented in PostgreSQL (how pgsql point to a
record from an index)?

- Could copying tables and indexes have had an effect on indexes?

- How can I verify that some of the indexes were not corrupted?

Daniel

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sameer Kumar 2015-05-17 04:25:41 Re: Moving Database Cluster to another drive
Previous Message Sameer Kumar 2015-05-14 23:10:23 Re: Managing PostgreSQL Streaming Replication Cluster