pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedEstimate the size of the SQL file generated by pg_dump utility
10+ messages / 9 participants
[nested] [flat]
* Estimate the size of the SQL file generated by pg_dump utility
@ 2007-03-05 14:55 Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-05 15:34 ` Re: Estimate the size of the SQL file generated by pg_dump utility A. Kretschmer <andreas.kretschmer@schollglas.com>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
0 siblings, 2 replies; 10+ messages in thread
From: Ravindran G-TLS,Chennai. @ 2007-03-05 14:55 UTC (permalink / raw)
To: pgsql-performance; +Cc: Arun Prasad S-TLS,Chennai. <arunps@hcl.in>
Dear All,
I have to take backup of a database as a SQL file using the pg_dump
utility and I have to check the disk space
before taking the backup. Hence I need to estimate the size of the
pg_dump output.
The size given by pg_database_size procedure and the size of file
generated by pg_dump
vary to a large extent. Kindly let me know how to estimate the size of
the file that pg_dump generates.
Note: Please bear with us for the disclaimer because it is automated in
the exchange server.
Regards,
Ravi
DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.
-----------------------------------------------------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
@ 2007-03-05 15:34 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
1 sibling, 0 replies; 10+ messages in thread
From: A. Kretschmer @ 2007-03-05 15:34 UTC (permalink / raw)
To: pgsql-performance
am Mon, dem 05.03.2007, um 20:25:21 +0530 mailte Ravindran G-TLS,Chennai. folgendes:
> Dear All,
>
> I have to take backup of a database as a SQL file using the pg_dump utility and
> I have to check the disk space
>
> before taking the backup. Hence I need to estimate the size of the pg_dump
> output.
You can take a empty backup by pipe the output to wc -c. Is this a
solution for you? You can see the result size in bytes.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
@ 2007-03-06 00:19 ` Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
1 sibling, 1 reply; 10+ messages in thread
From: Bruce Momjian @ 2007-03-06 00:19 UTC (permalink / raw)
To: Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>; +Cc: pgsql-performance@postgresql.org, "Arun Prasad S-TLS,Chennai." <arunps@hcl.in>
Ravindran G-TLS,Chennai. wrote:
> Note: Please bear with us for the disclaimer because it is automated in
> the exchange server.
> Regards,
> Ravi
FYI, we are getting closer to rejecting any email with such a
disclaimer, or emailing you back every time saying we are ignoring the
disclaimer.
---------------------------------------------------------------------------
>
>
> DISCLAIMER:
> -----------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
> this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
> Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
> this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
> received this email in error please delete it and notify the sender immediately. Before opening any mail and
> attachments please check them for viruses and defect.
>
> -----------------------------------------------------------------------------------------------------------------------
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
@ 2007-03-06 02:19 ` Bricklen Anderson <banderson@presinet.com>
2007-03-06 02:22 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 10+ messages in thread
From: Bricklen Anderson @ 2007-03-06 02:19 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>; pgsql-performance@postgresql.org, "Arun Prasad S-TLS,Chennai." <arunps@hcl.in>
Bruce Momjian wrote:
> Ravindran G-TLS,Chennai. wrote:
>> Note: Please bear with us for the disclaimer because it is automated in
>> the exchange server.
>> Regards,
>> Ravi
>
> FYI, we are getting closer to rejecting any email with such a
> disclaimer, or emailing you back every time saying we are ignoring the
> disclaimer.
I think this issue cropped up a year or two ago, and one of the
suggestions was for the offender to simply put a link back to their
disclaimer at the foot of their email, rather than that uber-verbose
message.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
@ 2007-03-06 02:22 ` Bruce Momjian <bruce@momjian.us>
2007-03-06 13:44 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bill Moran <wmoran@collaborativefusion.com>
0 siblings, 1 reply; 10+ messages in thread
From: Bruce Momjian @ 2007-03-06 02:22 UTC (permalink / raw)
To: Bricklen Anderson <banderson@presinet.com>; +Cc: Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>; pgsql-performance@postgresql.org, "Arun Prasad S-TLS,Chennai." <arunps@hcl.in>
Bricklen Anderson wrote:
> Bruce Momjian wrote:
> > Ravindran G-TLS,Chennai. wrote:
> >> Note: Please bear with us for the disclaimer because it is automated in
> >> the exchange server.
> >> Regards,
> >> Ravi
> >
> > FYI, we are getting closer to rejecting any email with such a
> > disclaimer, or emailing you back every time saying we are ignoring the
> > disclaimer.
>
> I think this issue cropped up a year or two ago, and one of the
> suggestions was for the offender to simply put a link back to their
> disclaimer at the foot of their email, rather than that uber-verbose
> message.
Right. The problem is that most of the posters have no control over
their footers --- it is added by their email software.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
2007-03-06 02:22 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
@ 2007-03-06 13:44 ` Bill Moran <wmoran@collaborativefusion.com>
2007-03-06 15:07 ` Re: Estimate the size of the SQL file generated by pg_dump utility Craig A. James <cjames@modgraph-usa.com>
0 siblings, 1 reply; 10+ messages in thread
From: Bill Moran @ 2007-03-06 13:44 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Bricklen Anderson <banderson@presinet.com>; Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>; pgsql-performance@postgresql.org, "Arun Prasad S-TLS,Chennai." <arunps@hcl.in>
In response to Bruce Momjian <bruce@momjian.us>:
> Bricklen Anderson wrote:
> > Bruce Momjian wrote:
> > > Ravindran G-TLS,Chennai. wrote:
> > >> Note: Please bear with us for the disclaimer because it is automated in
> > >> the exchange server.
> > >> Regards,
> > >> Ravi
> > >
> > > FYI, we are getting closer to rejecting any email with such a
> > > disclaimer, or emailing you back every time saying we are ignoring the
> > > disclaimer.
> >
> > I think this issue cropped up a year or two ago, and one of the
> > suggestions was for the offender to simply put a link back to their
> > disclaimer at the foot of their email, rather than that uber-verbose
> > message.
>
> Right. The problem is that most of the posters have no control over
> their footers --- it is added by their email software.
I'm curious, what problem does the disclaimer cause?
I wrote the following TOS for my personal system:
https://www.potentialtech.com/cms/node/9
Excerpt of the relevant part:
"If you send me email, you are granting me the unrestricted right to use
the contents of that email however I see fit, unless otherwise agreed in
writing beforehand. You have no rights to the privacy of any email that you
send me. If I feel the need, I will forward emails to authorities or make
their contents publicly available. By sending me email you consent to this
policy and agree that it overrides any disclaimers or policies that may
exist elsewhere."
I have no idea if that's legally binding or not, but I've talked to a few
associates who have some experience in law, and they all argue that email
disclaimers probably aren't legally binding anyway -- so the result is
undefined.
Don't know if this addresses the issue or confuses it ... ?
--
Bill Moran
Collaborative Fusion Inc.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
2007-03-06 02:22 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 13:44 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bill Moran <wmoran@collaborativefusion.com>
@ 2007-03-06 15:07 ` Craig A. James <cjames@modgraph-usa.com>
2007-03-06 15:09 ` Re: Estimate the size of the SQL file generated by pg_dump utility Claus Guttesen <kometen@gmail.com>
2007-03-06 15:31 ` Re: Estimate the size of the SQL file generated by pg_dump utility Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 10+ messages in thread
From: Craig A. James @ 2007-03-06 15:07 UTC (permalink / raw)
To: Bill Moran <wmoran@collaborativefusion.com>; +Cc: pgsql-performance
Bill Moran wrote:
> I'm curious, what problem does the disclaimer cause?
>
> I wrote the following TOS for my personal system:
> https://www.potentialtech.com/cms/node/9
> Excerpt of the relevant part:
> "If you send me email, you are granting me the unrestricted right to use
> the contents of that email however I see fit, unless otherwise agreed in
> writing beforehand. You have no rights to the privacy of any email that you
> send me. If I feel the need, I will forward emails to authorities or make
> their contents publicly available. By sending me email you consent to this
> policy and agree that it overrides any disclaimers or policies that may
> exist elsewhere."
>
> I have no idea if that's legally binding or not, but I've talked to a few
> associates who have some experience in law, and they all argue that email
> disclaimers probably aren't legally binding anyway -- so the result is
> undefined.
No, it's not legally binding. Agreements are only binding if both parties agree, and someone sending you email has not consented to your statement. If I send you something with a copyright mark, you'd better respect it unless you have a signed agreement granting you rights. Federal law always wins.
Disclaimers are bad for two reasons. First, they're powerless. Just because Acme Corp. attaches a disclaimer doesn't mean they've absolved themselves of responsibility for the actions of their employees. Second, they're insulting to the employees. It's a big red flag saying, "We, Acme Corp., hire clowns we don't trust, and THIS person may be one of them!"
Craig
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
2007-03-06 02:22 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 13:44 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bill Moran <wmoran@collaborativefusion.com>
2007-03-06 15:07 ` Re: Estimate the size of the SQL file generated by pg_dump utility Craig A. James <cjames@modgraph-usa.com>
@ 2007-03-06 15:09 ` Claus Guttesen <kometen@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Claus Guttesen @ 2007-03-06 15:09 UTC (permalink / raw)
To: Craig A. James <cjames@modgraph-usa.com>; +Cc: Bill Moran <wmoran@collaborativefusion.com>; pgsql-performance
> > I'm curious, what problem does the disclaimer cause?
> >
> > I wrote the following TOS for my personal system:
> > https://www.potentialtech.com/cms/node/9
> > Excerpt of the relevant part:
> > I have no idea if that's legally binding or not, but I've talked to a few
> > associates who have some experience in law, and they all argue that email
> > disclaimers probably aren't legally binding anyway -- so the result is
> > undefined.
>
> No, it's not legally binding. Agreements are only binding if both parties agree, and someone sending you email has not consented to your statement. If I send you something with a copyright mark, you'd better respect it unless you have a signed agreement granting you rights. Federal law always wins.
>
> Disclaimers are bad for two reasons. First, they're powerless. Just because Acme Corp. attaches a disclaimer doesn't mean they've absolved themselves of responsibility for the actions of their employees. Second, they're insulting to the employees. It's a big red flag saying, "We, Acme Corp., hire clowns we don't trust, and THIS person may be one of them!"
Dear sirs, this is off-topic at best. Pls. discontinue this thread.
regards
Claus
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
2007-03-06 02:22 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 13:44 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bill Moran <wmoran@collaborativefusion.com>
2007-03-06 15:07 ` Re: Estimate the size of the SQL file generated by pg_dump utility Craig A. James <cjames@modgraph-usa.com>
@ 2007-03-06 15:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-03-06 17:05 ` Re: Estimate the size of the SQL file generated by pg_dump utility Richard Troy <rtroy@ScienceTools.com>
1 sibling, 1 reply; 10+ messages in thread
From: Tom Lane @ 2007-03-06 15:31 UTC (permalink / raw)
To: Craig A. James <cjames@modgraph-usa.com>; +Cc: Bill Moran <wmoran@collaborativefusion.com>; pgsql-performance
"Craig A. James" <cjames@modgraph-usa.com> writes:
> Bill Moran wrote:
>> I have no idea if that's legally binding or not, but I've talked to a few
>> associates who have some experience in law, and they all argue that email
>> disclaimers probably aren't legally binding anyway -- so the result is
>> undefined.
> No, it's not legally binding. Agreements are only binding if both
> parties agree, and someone sending you email has not consented to your
> statement.
To take this back to the PG problem: it's probably true that we can
ignore disclaimers as far as receiving, redistributing, and archiving
mail list submissions goes. On the other hand, accepting a patch is
another matter.
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Estimate the size of the SQL file generated by pg_dump utility
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
2007-03-06 02:22 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 13:44 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bill Moran <wmoran@collaborativefusion.com>
2007-03-06 15:07 ` Re: Estimate the size of the SQL file generated by pg_dump utility Craig A. James <cjames@modgraph-usa.com>
2007-03-06 15:31 ` Re: Estimate the size of the SQL file generated by pg_dump utility Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-03-06 17:05 ` Richard Troy <rtroy@ScienceTools.com>
0 siblings, 0 replies; 10+ messages in thread
From: Richard Troy @ 2007-03-06 17:05 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Craig A. James <cjames@modgraph-usa.com>; Bill Moran <wmoran@collaborativefusion.com>; pgsql-performance
On Tue, 6 Mar 2007, Tom Lane wrote:
> "Craig A. James" <cjames@modgraph-usa.com> writes:
> > Bill Moran wrote:
> >> I have no idea if that's legally binding or not, but I've talked to a few
> >> associates who have some experience in law, and they all argue that email
> >> disclaimers probably aren't legally binding anyway -- so the result is
> >> undefined.
>
> > No, it's not legally binding. Agreements are only binding if both
> > parties agree, and someone sending you email has not consented to your
> > statement.
>
> To take this back to the PG problem: it's probably true that we can
> ignore disclaimers as far as receiving, redistributing, and archiving
> mail list submissions goes. On the other hand, accepting a patch is
> another matter.
A published policy on patch submission making them fit whatever legal
model is desired would avoid any and all legal issues related to legalease
included with a submission. The would-be patcher's action of submission
can also count as acknowledgement of the actual agreement - your
agreement - if you've got the policy unambiguously and prominently
displayed...
HTH,
RT
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2007-03-06 17:05 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-05 14:55 Estimate the size of the SQL file generated by pg_dump utility Ravindran G-TLS,Chennai. <ravindran_g@hcl.in>
2007-03-05 15:34 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2007-03-06 00:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 02:19 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bricklen Anderson <banderson@presinet.com>
2007-03-06 02:22 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bruce Momjian <bruce@momjian.us>
2007-03-06 13:44 ` Re: Estimate the size of the SQL file generated by pg_dump utility Bill Moran <wmoran@collaborativefusion.com>
2007-03-06 15:07 ` Re: Estimate the size of the SQL file generated by pg_dump utility Craig A. James <cjames@modgraph-usa.com>
2007-03-06 15:09 ` Re: Estimate the size of the SQL file generated by pg_dump utility Claus Guttesen <kometen@gmail.com>
2007-03-06 15:31 ` Re: Estimate the size of the SQL file generated by pg_dump utility Tom Lane <tgl@sss.pgh.pa.us>
2007-03-06 17:05 ` Re: Estimate the size of the SQL file generated by pg_dump utility Richard Troy <rtroy@ScienceTools.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox