Lists: | pgsql-general |
---|
From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dumpall custom format? |
Date: | 2009-03-05 10:53:07 |
Message-ID: | bddc86150903050253w6d276a3bn851558a538eca59e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi,
I noticed that while pg_dump can output a custom format, effectively
compressing the output, pg_dumpall doesn't. Is there a reason for this?
And is there a way to get pg_dumpall to compress it's output?
Thanks
Thom
From: | "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | "Thom Brown" <thombrown(at)gmail(dot)com>, "pgsql general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2009-03-05 11:02:56 |
Message-ID: | C4DAC901169B624F933534A26ED7DF311D540F@JENMAIL01.ad.intershop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hello,
you can first pipe the output of pg_dump to a compression tool:
pg_dump..... | gzip > file.
instead of gzip, I'm using pigz which is faster thanks multithreading.
HTH,
Marc Mamin
________________________________
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Thom Brown
Sent: Thursday, March 05, 2009 11:53 AM
To: pgsql general
Subject: [GENERAL] pg_dumpall custom format?
Hi,
I noticed that while pg_dump can output a custom format, effectively
compressing the output, pg_dumpall doesn't. Is there a reason for this?
And is there a way to get pg_dumpall to compress it's output?
Thanks
Thom
From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2009-03-05 11:08:10 |
Message-ID: | bddc86150903050308w5447dc84kbcb09b97859e7ee1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Thanks for the suggestion Marc. It would still be nice to have the custom
format included as an option though with pg_restore supporting it, just for
consistency.
I will, however, follow your recommendation.
Thom
2009/3/5 Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
> Hello,
>
> you can first pipe the output of pg_dump to a compression tool:
>
> pg_dump..... | gzip > file.
>
> instead of gzip, I'm using pigz which is faster thanks multithreading.
>
> HTH,
>
> Marc Mamin
>
>
>
> ------------------------------
> *From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *Thom Brown
> *Sent:* Thursday, March 05, 2009 11:53 AM
> *To:* pgsql general
> *Subject:* [GENERAL] pg_dumpall custom format?
>
> Hi,
>
> I noticed that while pg_dump can output a custom format, effectively
> compressing the output, pg_dumpall doesn't. Is there a reason for this?
> And is there a way to get pg_dumpall to compress it's output?
>
> Thanks
>
> Thom
>
From: | Ashish Karalkar <ashishka(at)synechron(dot)com> |
---|---|
To: | |
Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | PostgreSQL template for cacti |
Date: | 2009-03-05 11:20:11 |
Message-ID: | 49AFB56B.2060505@synechron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hello list,
I was wondering is there any postgresql template for cacti to monitor
PostgreSQL server.
can anybody plz point me to the same?
Thanks in advance
--Ashish
From: | Ashish Karalkar <ashishka(at)synechron(dot)com> |
---|---|
To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL template for cacti |
Date: | 2009-03-05 11:38:56 |
Message-ID: | 49AFB9D0.80508@synechron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Ashish Karalkar wrote:
> Hello list,
>
> I was wondering is there any postgresql template for cacti to monitor
> PostgreSQL server.
>
> can anybody plz point me to the same?
>
> Thanks in advance
>
>
>
> --Ashish
>
That worked from google,
sorry for making noise...
http://forums.cacti.net/about23300.html
--Ashish
From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2010-05-13 12:12:11 |
Message-ID: | AANLkTimxe2YrbJWq_cF56tnYt0Jwq_oul78QkxvSooiV@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> Thanks for the suggestion Marc. It would still be nice to have the custom
> format included as an option though with pg_restore supporting it, just for
> consistency.
>
> I will, however, follow your recommendation.
>
> Thom
>
> 2009/3/5 Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
>
> Hello,
>>
>> you can first pipe the output of pg_dump to a compression tool:
>>
>> pg_dump..... | gzip > file.
>>
>> instead of gzip, I'm using pigz which is faster thanks multithreading.
>>
>> HTH,
>>
>> Marc Mamin
>>
>>
>>
>> ------------------------------
>> *From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
>> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *Thom Brown
>> *Sent:* Thursday, March 05, 2009 11:53 AM
>> *To:* pgsql general
>> *Subject:* [GENERAL] pg_dumpall custom format?
>>
>> Hi,
>>
>> I noticed that while pg_dump can output a custom format, effectively
>> compressing the output, pg_dumpall doesn't. Is there a reason for this?
>> And is there a way to get pg_dumpall to compress it's output?
>>
>> Thanks
>>
>> Thom
>>
>
>
I'm bringing this thread back to life to see if there are any further
thoughts on this. It would be nice to have a complete backup of a database
cluster in custom format, and use pg_restore to restore an individual
database in the same way that it can restore individual schemas and tables
etc.
Thanks
Thom
From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2010-05-13 16:49:16 |
Message-ID: | 4BEC2D8C.3090408@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Le 13/05/2010 14:12, Thom Brown a écrit :
> On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
>> [...]
> I'm bringing this thread back to life to see if there are any further
> thoughts on this. It would be nice to have a complete backup of a database
> cluster in custom format, and use pg_restore to restore an individual
> database in the same way that it can restore individual schemas and tables
> etc.
>
Nope. But this is something I'd like to have too. I didn't actually look
into it much more (I mean, in the code), but I intend to work on this
for 9.1 (and other pg_dump stuff).
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2010-05-13 17:24:35 |
Message-ID: | AANLkTikaXUAvzU46UNk_0BOPB27zQZr35xFW93_yTqsp@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 13 May 2010 17:49, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> Le 13/05/2010 14:12, Thom Brown a écrit :
> > On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> >> [...]
> > I'm bringing this thread back to life to see if there are any further
> > thoughts on this. It would be nice to have a complete backup of a
> database
> > cluster in custom format, and use pg_restore to restore an individual
> > database in the same way that it can restore individual schemas and
> tables
> > etc.
> >
>
> Nope. But this is something I'd like to have too. I didn't actually look
> into it much more (I mean, in the code), but I intend to work on this
> for 9.1 (and other pg_dump stuff).
>
>
>
You're now my favourite PostgreSQL developer! Thanks Guillaume!
Thom
From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2010-05-13 17:28:09 |
Message-ID: | 4BEC36A9.4040101@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Le 13/05/2010 19:24, Thom Brown a écrit :
> On 13 May 2010 17:49, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>
>> Le 13/05/2010 14:12, Thom Brown a écrit :
>>> On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
>>>> [...]
>>> I'm bringing this thread back to life to see if there are any further
>>> thoughts on this. It would be nice to have a complete backup of a
>> database
>>> cluster in custom format, and use pg_restore to restore an individual
>>> database in the same way that it can restore individual schemas and
>> tables
>>> etc.
>>>
>>
>> Nope. But this is something I'd like to have too. I didn't actually look
>> into it much more (I mean, in the code), but I intend to work on this
>> for 9.1 (and other pg_dump stuff).
>>
>>
>>
> You're now my favourite PostgreSQL developer! Thanks Guillaume!
>
Don't get your expectations too high. I just said I'll try :)
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2010-05-17 12:28:53 |
Message-ID: | AANLkTil4Vnguuh-G3-ZeKQ2oopdEYVUaysAVMxJu47wi@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 13 May 2010 18:28, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> Le 13/05/2010 19:24, Thom Brown a écrit :
> > On 13 May 2010 17:49, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> >
> >> Le 13/05/2010 14:12, Thom Brown a écrit :
> >>> On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> >>>> [...]
> >>> I'm bringing this thread back to life to see if there are any further
> >>> thoughts on this. It would be nice to have a complete backup of a
> >> database
> >>> cluster in custom format, and use pg_restore to restore an individual
> >>> database in the same way that it can restore individual schemas and
> >> tables
> >>> etc.
> >>>
> >>
> >> Nope. But this is something I'd like to have too. I didn't actually look
> >> into it much more (I mean, in the code), but I intend to work on this
> >> for 9.1 (and other pg_dump stuff).
> >>
> >>
> >>
> > You're now my favourite PostgreSQL developer! Thanks Guillaume!
> >
>
> Don't get your expectations too high. I just said I'll try :)
>
>
I guess this will also require changes to pg_restore to support:
-g globals only
-r roles only
-t tablespaces (conflicts with pg_restore's table specification of -t)
And of course being able to restore individual databases and specifying
restoration of a table/function/trigger within specific databases. I guess
that could be done by specifying a database to restore, then asking for a
single function.
e.g.:
pg_restore --database=my_source_database -P my_function(argtype) -d
my_destination_database /database/backup/file
And adding database entry support to the listing file.
Thom
From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2010-05-17 20:54:09 |
Message-ID: | 4BF1ACF1.5080602@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Le 17/05/2010 14:28, Thom Brown a écrit :
> On 13 May 2010 18:28, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>
>> Le 13/05/2010 19:24, Thom Brown a écrit :
>>> On 13 May 2010 17:49, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>>>
>>>> Le 13/05/2010 14:12, Thom Brown a écrit :
>>>>> On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
>>>>>> [...]
>>>>> I'm bringing this thread back to life to see if there are any further
>>>>> thoughts on this. It would be nice to have a complete backup of a
>>>> database
>>>>> cluster in custom format, and use pg_restore to restore an individual
>>>>> database in the same way that it can restore individual schemas and
>>>> tables
>>>>> etc.
>>>>>
>>>>
>>>> Nope. But this is something I'd like to have too. I didn't actually look
>>>> into it much more (I mean, in the code), but I intend to work on this
>>>> for 9.1 (and other pg_dump stuff).
>>>>
>>>>
>>>>
>>> You're now my favourite PostgreSQL developer! Thanks Guillaume!
>>>
>>
>> Don't get your expectations too high. I just said I'll try :)
>>
>>
> I guess this will also require changes to pg_restore to support:
>
> -g globals only
> -r roles only
> -t tablespaces (conflicts with pg_restore's table specification of -t)
>
Yes.
> And of course being able to restore individual databases and specifying
> restoration of a table/function/trigger within specific databases. I guess
> that could be done by specifying a database to restore, then asking for a
> single function.
>
> e.g.:
>
> pg_restore --database=my_source_database -P my_function(argtype) -d
> my_destination_database /database/backup/file
>
Yes.
> And adding database entry support to the listing file.
>
And adding a role and a tablespace entries. And prefixing every object
with the database they belong too.
It won't be easy, but it's really something lacking right now. Or at
least, I think so :)
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2011-06-22 15:17:59 |
Message-ID: | BANLkTi=mNsR7zyUWFjhzNOLF97=gvdknmA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 13 May 2010 18:28, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> Le 13/05/2010 19:24, Thom Brown a écrit :
>> On 13 May 2010 17:49, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>>
>>> Le 13/05/2010 14:12, Thom Brown a écrit :
>>>> On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
>>>>> [...]
>>>> I'm bringing this thread back to life to see if there are any further
>>>> thoughts on this. It would be nice to have a complete backup of a
>>> database
>>>> cluster in custom format, and use pg_restore to restore an individual
>>>> database in the same way that it can restore individual schemas and
>>> tables
>>>> etc.
>>>>
>>>
>>> Nope. But this is something I'd like to have too. I didn't actually look
>>> into it much more (I mean, in the code), but I intend to work on this
>>> for 9.1 (and other pg_dump stuff).
>>>
>>>
>>>
>> You're now my favourite PostgreSQL developer! Thanks Guillaume!
>>
>
> Don't get your expectations too high. I just said I'll try :)
Have you had any opportunity to look at this yet? :)
Thanks
Thom
From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2011-06-24 17:47:09 |
Message-ID: | 1308937630.1995.43.camel@laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Wed, 2011-06-22 at 16:17 +0100, Thom Brown wrote:
> On 13 May 2010 18:28, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> > Le 13/05/2010 19:24, Thom Brown a écrit :
> >> On 13 May 2010 17:49, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> >>
> >>> Le 13/05/2010 14:12, Thom Brown a écrit :
> >>>> On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> >>>>> [...]
> >>>> I'm bringing this thread back to life to see if there are any further
> >>>> thoughts on this. It would be nice to have a complete backup of a
> >>> database
> >>>> cluster in custom format, and use pg_restore to restore an individual
> >>>> database in the same way that it can restore individual schemas and
> >>> tables
> >>>> etc.
> >>>>
> >>>
> >>> Nope. But this is something I'd like to have too. I didn't actually look
> >>> into it much more (I mean, in the code), but I intend to work on this
> >>> for 9.1 (and other pg_dump stuff).
> >>>
> >>>
> >>>
> >> You're now my favourite PostgreSQL developer! Thanks Guillaume!
> >>
> >
> > Don't get your expectations too high. I just said I'll try :)
>
> Have you had any opportunity to look at this yet? :)
>
Nope, still in my TODO list.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com