Re: pg_dump limit 1000 rows

Поиск
Список
Период
Сортировка
От drum.lucas@gmail.com
Тема Re: pg_dump limit 1000 rows
Дата
Msg-id CAE_gQfVd-Q1Fgo_BpPs1NtiGM1=KO82UjF8z6Trb1AeGbKrvMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump limit 1000 rows  (bricklen <bricklen@gmail.com>)
Ответы Re: pg_dump limit 1000 rows  (bricklen <bricklen@gmail.com>)
Список pgsql-admin
Дерево обсуждения


On Wed, Mar 2, 2016 at 4:56 PM, drum.lucas@gmail.com <drum.lucas@gmail.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: bricklen
Дата:
Сообщение: Re: pg_dump limit 1000 rows
Следующее
От: bricklen
Дата:
Сообщение: Re: pg_dump limit 1000 rows