Re: Restarting DB after moving to another drive - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Restarting DB after moving to another drive
Date
Msg-id CA+bJJbz0DBvY0oN7HPOb_7uAgYs0S2swOJMGMTE8GM30NsQaTg@mail.gmail.com
Whole thread Raw
In response to Re: Restarting DB after moving to another drive  (Daniel Begin <jfd553@hotmail.com>)
Responses Re: Restarting DB after moving to another drive
List pgsql-general
Hi Daniel:

On Wed, May 13, 2015 at 8:06 PM, Daniel Begin <jfd553@hotmail.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
aboutit!-). 

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.


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BDR table level replication questions
Next
From: Sachin Srivastava
Date:
Subject: template_postgis issue