On Sat, Feb 20, 2010 at 6:57 PM, Nilesh Govindarajan wrote:
> On 02/20/2010 11:23 PM, Scott Marlowe wrote:
>>
>> On Sat, Feb 20, 2010 at 10:11 AM, Nilesh Govindarajan
>> wrote:
>>>
>>> I want a script to backup all databases table by table in different .sql
>>> files.
>>
>> Why? It may be that p
Nilesh Govindarajan wrote:
> I can prevent the changes to the database when the
> backup is going on, but how do I grant the permissions ? I don't
> want to key in the password for the superuser in the script.
There are so many ways to deal with that that it's hard to make a
suggestion without
On 02/20/2010 11:14 PM, Kevin Grittner wrote:
Nilesh Govindarajan wrote:
I want a script to backup all databases table by table in different
.sql files.
My first question would be whether they all need to be from the same
point in time? Is it a requirement that if they were all restored
the
On 02/20/2010 11:23 PM, Scott Marlowe wrote:
On Sat, Feb 20, 2010 at 10:11 AM, Nilesh Govindarajan wrote:
I want a script to backup all databases table by table in different .sql
files.
Why? It may be that pg_dump / pg_restore already provide the
functionality you are looking for.
How to d
On Sat, Feb 20, 2010 at 10:11 AM, Nilesh Govindarajan wrote:
> I want a script to backup all databases table by table in different .sql
> files.
Why? It may be that pg_dump / pg_restore already provide the
functionality you are looking for.
> How to do this ?
pg_dump -t tablename dbname
rinse
Nilesh Govindarajan wrote:
> I want a script to backup all databases table by table in different
> .sql files.
My first question would be whether they all need to be from the same
point in time? Is it a requirement that if they were all restored
they would provide a database with referential
I want a script to backup all databases table by table in different .sql
files.
How to do this ?
Also since it is a script, there has to be some role having read access
to all tables on all databases. How to grant that ?
--
Nilesh Govindarajan
Site & Server Adminstrator
www.itech7.com
--
Se
: mcelroy, tim
Cc: 'Bruno Wolff III'; 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] backups
On Wed, 2006-05-10 at 14:11, mcelroy, tim wrote:
> Excellent point Bruno, thanks. I must admit that I did think of that
> and have already copied all my
Title: RE: [ADMIN] backups
Thanks Scott, great idea. Does one use pg_restore to restore the files that pg_dumpall creates?
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2006 3:35 PM
To: mcelroy, tim
Cc: 'Bruno Wolf
On Wed, 2006-05-10 at 14:11, mcelroy, tim wrote:
> Excellent point Bruno, thanks. I must admit that I did think of that
> and have already copied all my .conf files to the backup directory. I
> should have noted that earlier.
>
> Thanks,
> Tim
Another thing to check is that your global data (i.
Title: RE: backups
Excellent point Bruno, thanks. I must admit that I did think of that and have already copied all my .conf files to the backup directory. I should have noted that earlier.
Thanks,
Tim
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]]
Sent:
On Wed, May 10, 2006 at 11:56:20 -0400,
"mcelroy, tim" <[EMAIL PROTECTED]> wrote:
> Thanks for the quick answer Scott. I thought so but wanted to double-check.
> I was asked by the person who performs our system backups if just backing up
> the directory where I put the nightly backups (created
Title: RE: [ADMIN] backups
Great, exactly the answer I was looking for. Thank you again Scott.
Tim
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2006 12:12 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org
On Wed, 2006-05-10 at 10:56, mcelroy, tim wrote:
> Thanks for the quick answer Scott. I thought so but wanted to
> double-check. I was asked by the person who performs our system
> backups if just backing up the directory where I put the nightly
> backups (created with pg_dump) was enough. I als
Title: RE: [ADMIN] backups
Thanks for the quick answer Scott. I thought so but wanted to double-check. I was asked by the person who performs our system backups if just backing up the directory where I put the nightly backups (created with pg_dump) was enough. I also have them backing up
On Wed, 2006-05-10 at 10:49, mcelroy, tim wrote:
> Greetings,
>
>
>
> Does the pg_dump command ‘backup’ the pg_xlog files?
No. Those are internal files used by the database to maintain
transactional integrity. The pg_dump command backs up the database as
snapshotted at a specific point of ti
Title: dbsize & pg_dump
Greetings,
Does the
pg_dump command ‘backup’ the pg_xlog files?
Thank you,
Tim
[EMAIL PROTECTED] writes:
> Now my question: my employer wants to do backups every 12 hours, and
> save the logs evry 2 hours to... Can I simply save the logs
> (cp pg_xlog/* ...) or do I need something more elaborate?
You can't realistically do this in any pre-8.0 release; it's perhaps
doable in
What I meant(And I guess that Pablo asked for this also), was that is not easy to
found information or howto work on the pg_xlog directory.
I didn't take it as "read the FINE manual" anyway ;)
Regards,
Guido
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> G u i d o B a r o s i o wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
G u i d o B a r o s i o wrote:
| On this issue,
|
|
|
|Is a good idea to ln -s the pg_xlog directory onto another place, while the
postmaster is running?
I don't think so
| I agree with pablo, documentation at this point is not easy to found.
On this issue,
Is a good idea to ln -s the pg_xlog directory onto another place, while the
postmaster is running?
I agree with pablo, documentation at this point is not easy to found.
Regards,
> [EMAIL PROTECTED] wrote:
>
> > Hi, first of all thanks for postgresql, it has never given
[EMAIL PROTECTED] wrote:
Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.
Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs
(cp pg_xlog/* ...) or do I need something more ela
Hi, first of all thanks for postgresql, it has never given a problem
and is performing great.
Now my question: my employer wants to do backups every 12 hours, and
save the logs evry 2 hours to... Can I simply save the logs
(cp pg_xlog/* ...) or do I need something more elaborate?
Now in a restor
Hello list,
just a quick question a colleague asked me (and I too am curious): suppose
during a pg_dump PostgreSQL finds an error in a table (disk error, file
corrupted etc). Where does it blame for the error? Standard output? Log
file? Anywhere else?
Thanks in advance,
Stefano
-
24 matches
Mail list logo
