...@postgresql.org] On Behalf Of Daniel Begin
Sent: May-15-15 15:17
To: 'Francisco Olarte'
Cc: r...@iol.ie; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
Thank for that comprehensive response!
And you are right about practicing restore, I ne
al-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Francisco Olarte
Sent: May-15-15 12:20
To: Daniel Begin
Cc: r...@iol.ie; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
HI Daniel:
On Fri, May 15, 2015 at 5:35 PM, Daniel Begin
HI Daniel:
On Fri, May 15, 2015 at 5:35 PM, Daniel Begin wrote:
> Bonjour Francisco.
Buenos dias.
> Skimming the documentation sequentially is a cleaver advice, especially since
> the doc is much of the time well done and exhaustive. Unfortunately, even if
> I actually did it about 1 year ago,
ql.org] On Behalf Of Francisco Olarte
Sent: May-15-15 05:12
To: Daniel Begin
Cc: r...@iol.ie; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
Hi Daniel:
On Wed, May 13, 2015 at 8:06 PM, Daniel Begin wrote:
...
> - I still have a lot to learn on data
I use this script, run nightly via crontab, on my small pgsql servers.
it runs as the postgres user.
#!/bin/bash
/usr/pgsql-9.3/bin/pg_dumpall --globals-only | gzip >
/home2/backups/pgsql/pgdumpall.globals.`date +\%a`.sql.gz
for db in $(psql -tc "select datname from pg_database where not
dati
Hi Daniel:
On Wed, May 13, 2015 at 8:06 PM, Daniel Begin 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
ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: May-13-15 14:16
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
On 5/13/2015 11:06 AM, Daniel Begin wrote:
> I am then currently running pg_dumpall
On 5/13/2015 11:06 AM, Daniel Begin wrote:
I am then currently running pg_dumpall on the database. I will restore the cluster on the
new drive once completed. However, there is still something obscure in the process. The
doc says "pg_dumpall requires all needed tablespace directories to exist b
gresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Francisco Olarte
Sent: May-13-15 06:57
To: Daniel Begin
Cc: r...@iol.ie; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
Hi Daniel:
On Mon, May 11, 2015 at 5:30 PM, Daniel Begin wrote
On 11 May 2015 at 19:01, Daniel Begin wrote:
> Interesting,
>
> The symbolic links on the old drive -still used by the DB- look like
> windows' shortcuts to parent folder, while they are empty folders in the
> copy of the database I have on the new drive...
>
> When I do a plane copy of those link
Hi Daniel:
On Mon, May 11, 2015 at 5:30 PM, Daniel Begin wrote:
> How big? According to PgAdmin my personal database is about 2TB...
I do not know what pgAdmin reports, I was thinking in how bick a dump
( using -Fc, which compresses on th fly ) is, to see wheter you can
restore.
> How critical?
g] On Behalf Of Marc Mamin
Sent: May-11-15 13:10
To: Daniel Begin; 'Francisco Olarte'
Cc: r...@iol.ie; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
Hi,
have you checked that the links in $PGDATA\pg_tblspc on the new drive are
valid ?
They possi
...@postgresql.org
[pgsql-general-ow...@postgresql.org]" im Auftrag von "Daniel Begin
[jfd...@hotmail.com]
Gesendet: Montag, 11. Mai 2015 17:30
An: 'Francisco Olarte'
Cc: r...@iol.ie; pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Restarting DB after moving to another drive
Franc
l.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Francisco Olarte
Sent: May-11-15 11:01
To: Daniel Begin
Cc: r...@iol.ie; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
Hi Daniel.
On Mon, May 11, 2015 at 4:42 PM, Daniel Begin wrote:
&
Hi Daniel.
On Mon, May 11, 2015 at 4:42 PM, Daniel Begin 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 tables
r
archive ) does normally the trick.
Francisco Olarte.
> -Original Message-
> From: Francisco Olarte [mailto:fola...@peoplecall.com]
> Sent: May-11-15 08:55
> To: Daniel Begin
> Subject: Re: [GENERAL] Restarting DB after moving to another drive
>
> Hi Daniel.
>
> On
Behalf Of Raymond O'Donnell
Sent: May-11-15 09:19
To: Daniel Begin; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
On 11/05/2015 13:38, Daniel Begin wrote:
> I just get it back running with the old drive - was some Windows
> hidd
On 11/05/2015 13:38, Daniel Begin wrote:
> I just get it back running with the old drive - was some Windows hidden
> behavior!
>
> However, does someone could tell me what went wrong with the procedure I
> used to move the DB?
> And/or what procedure I should have used in order to get it right?
O'Donnell [mailto:r...@iol.ie]
Sent: May-11-15 07:50
To: Daniel Begin; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restarting DB after moving to another drive
On 11/05/2015 12:03, Daniel Begin wrote:
> I am working on windows and I had to move my database on another hard
> driv
On 11/05/2015 12:03, Daniel Begin wrote:
> I am working on windows and I had to move my database on another hard
> drive after the original one started overheating. In order to move the
> DB I did the following…
>
>
>
> -Stop postgresql-x64-9.3 service – and wait until there were no more
> syst
20 matches
Mail list logo
