From: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
---|---|
To: | bricklen <bricklen(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump limit 1000 rows |
Date: | 2016-03-03 02:44:50 |
Message-ID: | CAE_gQfVd-Q1Fgo_BpPs1NtiGM1=KO82UjF8z6Trb1AeGbKrvMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
>
>
>
> On Wed, Mar 2, 2016 at 4:56 PM, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com
> > wrote:
>
>> I wanna do a minimal dump DB file. (I'm using PostgreSQL 9.2)
>> So I was thinking about getting the last 1000 rows data from some
>> tables....
>>
>
> Have a look at pg_sample, it should do exactly what you are looking to do.
> https://github.com/mla/pg_sample
>
Thanks Bricklen...
I've ran the pg_sample in a test server and it works!
But, in my main DB i'm getting the error:
> Creating table "_pg_sample"."pg_catalog_pg_statistic" DBD::Pg::db do
> failed: ERROR: column "stavalues1" has pseudo-type "anyarray" at
> ./pg_sample line 296
> main::__ANON__('DBD::Pg::db do failed: ERROR: column "stavalues1" has
> pseudo...', 'DBI::db=HASH(0x1f25c38)', undef) called at ./pg_sample line 538
> Dropping sample schema _pg_sample
> Done.
*Command:*
./pg_sample dbname --data-only --file=test.sql --limit="ja_admins = 1000"
--verbose
Would you know why do I get that error?
Cheers
From | Date | Subject | |
---|---|---|---|
Next Message | bricklen | 2016-03-03 02:59:09 | Re: pg_dump limit 1000 rows |
Previous Message | bricklen | 2016-03-03 01:04:24 | Re: pg_dump limit 1000 rows |