Re: Restarting DB after moving to another drive

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Daniel Begin <jfd553(at)hotmail(dot)com>
Cc: rod(at)iol(dot)ie, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restarting DB after moving to another drive
Date: 2015-05-15 09:12:26
Message-ID: CA+bJJbz0DBvY0oN7HPOb_7uAgYs0S2swOJMGMTE8GM30NsQaTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Daniel:

On Wed, May 13, 2015 at 8:06 PM, Daniel Begin <jfd553(at)hotmail(dot)com> wrote:
...
> - I still have a lot to learn on database management (it was simpler on user's side!-)

Yep, we all do, even if we've been using it since it was called Postgres.

> Fortunately, I have found that pg_dumpall could do the job (I did not have a problem with it, I just did not know about it!-).

If you didn't know about it I'll urge you to take the manual and do a
sequential reading ( maybe not in full, this would take a long time,
but at least skim through all of it sequentially, it's full of very
interesting info and it's very useful and when you hit a problem
you'll probably know there is something for it and search for it ).
For me the manual is one of the major points for using pg . pg_dumpall
is a fundamental tool for backups, as it's the only one that dumps the
global objects.

Good luck.

Francisco Olarte.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Srivastava 2015-05-15 09:35:27 template_postgis issue
Previous Message Craig Ringer 2015-05-15 07:30:31 Re: BDR table level replication questions