Adrian Klaver writes:
> On Saturday, September 24, 2011 7:16:11 am Roger Niederland wrote:
>> [ pg_dump 9.1 no longer honors -Z when emitting plain text ]
> Not sure why the compression was removed, there is no explanation in either
> the
> commit or the release notes. If you are interested, t
On Saturday, September 24, 2011 7:16:11 am Roger Niederland wrote:
> On 9/23/2011 5:18 PM, Adrian Klaver wrote:
> > On Friday, September 23, 2011 7:26:19 am Roger Niederland wrote:
> >> On 9/23/2011 6:46 AM, hubert depesz lubaczewski wrote:
> >>> On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Nied
On Sat, Sep 24, 2011 at 17:16, Roger Niederland wrote:
> Just did not expect that the compression would be removed for plain files.
Agreed, I'd say this is a regression that I would like to see
addressed in PostgreSQL 9.1.1. I'm sure you won't be the only to be
surprised by this.
The fact that t
On 9/23/2011 5:18 PM, Adrian Klaver wrote:
On Friday, September 23, 2011 7:26:19 am Roger Niederland wrote:
On 9/23/2011 6:46 AM, hubert depesz lubaczewski wrote:
On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
Using pg_dump from the command line with the exe included in wi
Oh, neat.
And I'll call myself wizard. People will think I am one...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2011/9/23 Gregg Jaskiewicz
> can you pipe things on windows ?
>
Yes you can. It surprised me positively several years ago.
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/redirection.mspx?mfr=true
> It's a desktop system after all,
:-) what a nice dose of condesc
On Friday, September 23, 2011 7:26:19 am Roger Niederland wrote:
> On 9/23/2011 6:46 AM, hubert depesz lubaczewski wrote:
> > On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
> >> Using pg_dump from the command line with the exe included in windows
> >> 32 bit install in postgresql
can you pipe things on windows ?
It's a desktop system after all, but dos had that sort of a feature -
I seem to remember.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 9/23/2011 6:46 AM, hubert depesz lubaczewski wrote:
On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
Using pg_dump from the command line with the exe included in windows
32 bit install in postgresql 9.1.
pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname
please note th
On Thursday, September 22, 2011 11:00:10 pm Roger Niederland wrote:
> Using pg_dump from the command line with the exe included in windows 32
> bit install in postgresql 9.1.
> pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname
>
> outputs a file that is in plain text. In previous versions of
On Thursday, September 22, 2011 11:00:10 pm Roger Niederland wrote:
> Using pg_dump from the command line with the exe included in windows 32
> bit install in postgresql 9.1.
> pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname
>
Ignore my previous post. I just realized that I was using the 9
On Friday, September 23, 2011 6:46:49 am hubert depesz lubaczewski wrote:
> On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
> > Using pg_dump from the command line with the exe included in windows
> > 32 bit install in postgresql 9.1.
> > pg_dump -U username -f somefile.sql.gz -Z
On Thursday, September 22, 2011 11:00:10 pm Roger Niederland wrote:
> Using pg_dump from the command line with the exe included in windows 32
> bit install in postgresql 9.1.
> pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname
>
> outputs a file that is in plain text. In previous versions of
On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
> Using pg_dump from the command line with the exe included in windows
> 32 bit install in postgresql 9.1.
> pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname
please note that pg_dump --help shows:
-Z, --compress=0-9
Excerpts from yasin malli's message of mar ago 31 00:44:36 -0400 2010:
> Hi everyone.
>
> I try this command ' pg_dump --compress=5 DBNAME > ***.sql ' and ' psql -f
> ***.sql -d DBNAME '
> but I take some error because of compression. how can restore compressed
> dump file without taking any error
On Tue, 2010-08-31 at 00:50 -0700, yasin malli wrote:
> I tried it and it ran without any error but my table wasn't created so
> problem is going on.
> compress level isn't important because when I controlled it gave me
> same results ( 5 or 9 )
>
> Unfortunately, only plain-old dump works correct
yasin malli writes:
> Unfortunately, only plain-old dump works correctly while restoring.
> if command contains any compress option, it won't work
--compress is normally used as an adjunct to -Fc.
I'm not real sure what you get if you specify it without that;
maybe a compressed plain-text-script
I tried it and it ran without any error but my table wasn't created so
problem is going on.
compress level isn't important because when I controlled it gave me same
results ( 5 or 9 )
Unfortunately, only plain-old dump works correctly while restoring.
if command contains any compress option, it wo
On 31 Aug 2010, at 8:17, yasin malli wrote:
Don't reply to just me, include the list.
> if I took my dump file with 'pg_dump -Ft ' command, I would use 'pg_restore',
> but I take my dump file at plain-old format for compressing data ( tar format
> dump hasn't compress feature )
> when I tried y
On 31 Aug 2010, at 6:44, yasin malli wrote:
> Hi everyone.
>
> I try this command ' pg_dump --compress=5 DBNAME > ***.sql ' and ' psql -f
> ***.sql -d DBNAME '
> but I take some error because of compression. how can restore compressed dump
> file without taking any error ?
By using pg_restore
20 matches
Mail list logo
