Re: pg_sample

2018-08-29 Thread Daniel Verite
Naveen Dabas wrote: > Creating sample schema sampledb1 > DBD::Pg::db do failed: ERROR: cannot execute CREATE SCHEMA in a read-only > transaction at ./pg_sample line 296. Maybe you ran this on a hot standby? It can't work because this program needs to write data into the database, which i

Re: pg_sample

2018-08-27 Thread Adrian Klaver
On 08/27/2018 08:33 AM, Naveen Dabas wrote: actually i want limited data from the postgres database. But i don't want to use .csv Does the sample need to include parent/child relationships? In Postgres 9.5+ there is TABLESAMPLE: https://www.postgresql.org/docs/10/static/sql-select.html So yo

Re: pg_sample

2018-08-27 Thread Naveen Dabas
actually i want limited data from the postgres database. But i don't want to use .csv thanks On Mon, Aug 27, 2018 at 7:42 PM, Adrian Klaver wrote: > On 08/26/2018 11:03 PM, Naveen Dabas wrote: > >> Server encoding is UTF8 >> Client encoding is UTF8 >> Creating sample schema sampledb1 >> DBD::

Re: pg_sample

2018-08-27 Thread Adrian Klaver
On 08/26/2018 11:03 PM, Naveen Dabas wrote: Server encoding is UTF8 Client encoding is UTF8 Creating sample schema sampledb1 DBD::Pg::db do failed: ERROR:  cannot execute CREATE SCHEMA in a read-only transaction at ./pg_sample line 296. main::__ANON__('DBD::Pg::db do failed: ERROR:  cannot execu

Re: pg_sample

2018-08-26 Thread Naveen Dabas
Server encoding is UTF8 Client encoding is UTF8 Creating sample schema sampledb1 DBD::Pg::db do failed: ERROR: cannot execute CREATE SCHEMA in a read-only transaction at ./pg_sample line 296. main::__ANON__('DBD::Pg::db do failed: ERROR: cannot execute CREATE SCHEMA i...', 'DBI::db=HASH(0xab2388)

Re: pg_sample

2018-08-26 Thread Paul Carlucci
sudo yum install perl-CPAN Also do a "yum search perl-" and you should find most, if not all what you need natively packaged for your particular Linux distro. You're better off just sticking with the pre-packaged perl modules unless you specifically need something special. You'll find more modul

Re: pg_sample

2018-08-26 Thread Naveen Dabas
Sir i'm getting error in both commands [root@ip-88-8-8-17 ~]# perl -MCPAN -e 'install Bundle::DBI' Can't locate CPAN.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .). BEGIN faile

Re: pg_sample

2018-08-24 Thread Abhinav Mehta
Solution, execute this on your linux terminal - $ perl -MCPAN -e 'install Bundle::DBI' $ perl -MCPAN -e 'install DBD::Pg' > On 24-Aug-2018, at 6:13 PM, Ravi Krishna wrote: > >> >> sir have taken pg_sample >> Now i want to run pg_sample with credential but i'm getting this error >> >> Can't l

Re: pg_sample

2018-08-24 Thread Ravi Krishna
> > sir have taken pg_sample > Now i want to run pg_sample with credential but i'm getting this error > > Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib64/perl5 > /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl > /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .)

Re: pg_sample

2018-08-24 Thread Naveen Dabas
sir have taken pg_sample Now i want to run pg_sample with credential but i'm getting this error Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at ./pg_sample li

Re: pg_sample

2018-08-23 Thread Adrian Klaver
On 08/23/2018 07:39 AM, Naveen Dabas wrote: sir from where should i install it. I tried but  i didn't found separate  link for pg_sample can you help me in this Something similar: https://github.com/18F/rdbms-subsetter It is Python based and can be pip installed. thanks -- Adrian Kl

Re: pg_sample

2018-08-23 Thread Adrian Klaver
On 08/23/2018 07:39 AM, Naveen Dabas wrote: sir from where should i install it. I tried but  i didn't found separate  link for pg_sample can you help me in this I am guessing it is this: https://github.com/mla/pg_sample -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_sample

2018-08-23 Thread Naveen Dabas
sir from where should i install it. I tried but i didn't found separate link for pg_sample can you help me in this thanks On Thu, Aug 23, 2018 at 6:34 PM, Adrian Klaver wrote: > On 08/23/2018 12:10 AM, naveen12 wrote: > >> i have installed postgresql on centos. >> i want to use pg_sample. >>

Re: pg_sample

2018-08-23 Thread Adrian Klaver
On 08/23/2018 12:10 AM, naveen12 wrote: i have installed postgresql on centos. i want to use pg_sample. Do i need to install that separately of it's included in the postgresql It is not included in the Postgres core or contrib packages. You will need to install it separately. -- Sent fr

Re: pg_sample

2018-08-23 Thread naveen12
i have installed postgresql on centos. i want to use pg_sample. Do i need to install that separately of it's included in the postgresql -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html