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 d

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::__

Re: pg_sample

2018-08-27 Thread Naveen Dabas
ample 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)', u

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:  c

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::d

Re: pg_sample

2018-08-26 Thread Paul Carlucci
failed--compilation aborted. > > > > operating system =CentOS Linux release 7.5.1804 (Core) > > thanks > > > On Fri, Aug 24, 2018 at 6:16 PM, Abhinav Mehta > wrote: > >> Solution, execute this on your linux terminal - >> >> $ perl -MCPAN -e 'install Bu

Re: pg_sample

2018-08-26 Thread Naveen Dabas
'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 locate DBI.pm in @I

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 creden

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 /u

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 .

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 -- A

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. >>

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. --

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