On Wed, Jul 26, 2017 at 11:36 PM, wrote:
> On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA
> wrote:
> >
> > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier <
> michael.paqu...@gmail.com> wrote:
> > On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA
> > wrot
On Wed, Jul 26, 2017 at 5:38 PM, Michael Paquier
wrote:
> On Wed, Jul 26, 2017 at 2:01 PM, PAWAN SHARMA
> wrote:
> > For root user its working fine
> >
> > [root@abc :/opt/PostgreSQL/9.5/data/pgaudit]#
> > #-> pgbadger -f stderr postgres-2
On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA
wrote:
>
> On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier <
> michael.paqu...@gmail.com> wrote:
>
>> On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA
>> wrote:
>> >
>> > Hi All,
>>
On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier
wrote:
> On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA
> wrote:
> >
> > Hi All,
> >
> > I am facing below error while parsing log file.
> >
> > [postgres@abc pgaudit]$ pgbadger -f stderr
> postgre
Hi All,
I am facing below error while parsing log file.
[postgres@abc pgaudit]$ pgbadger -f stderr postgres-2017-07-25_121445.csv
Can't locate Text/CSV_XS.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/
Hi All,
I am facing below error while parsing log file.
[postgres@abc pgaudit]$ pgbadger -f stderr postgres-2017-07-25_121445.csv
Can't locate Text/CSV_XS.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/
On Mon, Jul 24, 2017 at 7:28 PM, Tim Clarke
wrote:
>
>
> On 24/07/17 14:47, PAWAN SHARMA wrote:
> >
> > Hi Tim,
> >
> > Facing below issue
> >
> > [abc@test:/home/psharm89/nrpe-2.15]#
> > Redirecting to /bin/systemctl restart xinetd
On Mon, Jul 24, 2017 at 5:50 PM, PAWAN SHARMA
wrote:
>
> On Mon, Jul 24, 2017 at 5:20 PM, Tim Clarke
> wrote:
>
>> We use nagios for all alerting, it'll do what you need.
>>
>> Tim Clarke
>>
>>
>> On 24/07/17 12:38, Achilleas Mantzios wrote:
stem side, but more to the DBA side.
> > For system level monitoring maybe take a look here :
> > https://wiki.postgresql.org/wiki/Monitoring#check_postgres .
> > Also you might want to write a script that parses logs for FATAL and
> > PANIC and sends out emails.
&
Hi All,
Please provide me a list of tools which we can use for monitoring
PostgreSQL.
-Monitor all the services and health of server
-Able to send critical and warning alert on mail.
OS: Redhat-7
PostgreSQL Version: 9.5.7
-Pawan
On Wed, Jul 5, 2017 at 6:29 PM, Adrian Klaver
wrote:
> On 07/05/2017 05:25 AM, PAWAN SHARMA wrote:
>
>>
>>
>
>> Hi Moreno,
>>
>>
>> Thanks for response.
>>
>> 1. We don't have yum working on servers
>> 2. We are using rpm to in
On Jul 5, 2017 17:40, "Moreno Andreo" wrote:
Il 05/07/2017 13:35, PAWAN SHARMA ha scritto:
Hi All,
Please help me to install pgadmin3 or pgadmin4 on Redhat server.
https://yum.postgresql.org/repopackages.php#pg95
I have download pgdg-redhat95-9.5-3.noarch.rpm from the above link a
Hi All,
Please help me to install pgadmin3 or pgadmin4 on Redhat server.
https://yum.postgresql.org/repopackages.php#pg95
I have download pgdg-redhat95-9.5-3.noarch.rpm from the above link and
install successfully on my server.
what next how to configure it?
Using PostgreSQL Version : 9.5.7
On Fri, Jun 23, 2017 at 6:10 PM, Karsten Hilbert
wrote:
> On Fri, Jun 23, 2017 at 05:57:44PM +0530, PAWAN SHARMA wrote:
>
> > Please help to configure kitchen.yml to test the PostgreSQL cookbook
> > testing.
> >
> > #-> kitchen converge
>
Hi All,
Please help to configure kitchen.yml to test the PostgreSQL cookbook
testing.
#-> kitchen converge
-> Starting Kitchen (v1.16.0)
>> --Exception---
>> Class: Kitchen::UserError
>> Message: Error parsing /tmp/postgresql-master/.kitchen.yml as YAML.
Please run `kitche
Hi All,
I am new to chef concept, can anyone provide me a cookbook for doing
installation and configuration of PostgreSQL on Redhat.
I have checked so many cookbooks in the supermarket.
-Pawan
On Sat, Jun 3, 2017 at 1:48 AM, Igor Neyman wrote:
>
> I wonder, does plpgsql compilation check for existence of the
> add_job_history function or is that a runtime check?
>
>
>
> At runtime.
>
>
Hi Neyman,
Thanks it's done by
On Fri, Jun 2, 2017 at 2:13 PM, Pavel Stehule
wrote:
> Hi
>
> 2017-06-02 10:16 GMT+02:00 PAWAN SHARMA :
>
>> Hi All,
>>
>> I am migrating Oracle database into PostgreSQL using Ora2PG tool.
>>
>> So, I am facing one issue with trigger after gene
se excuse my clumbsy thums.
>
> On Jun 2, 2017, at 04:16, PAWAN SHARMA wrote:
>
> Hi All,
>
> I am migrating Oracle database into PostgreSQL using Ora2PG tool.
>
> So, I am facing one issue with trigger after generating script output of
> Oracle database.
>
> *Oracl
Hi All,
I am migrating Oracle database into PostgreSQL using Ora2PG tool.
So, I am facing one issue with trigger after generating script output of
Oracle database.
*Oracle : *
CREATE OR REPLACE TRIGGER UPDATE_JOB_HISTORY
AFTER UPDATE OF JOB_ID, DEPARTMENT_ID ON EMPLOYEES
FOR EACH ROW
BE
Hi All,
What is the formula to calculate estimated cost in Ora2Pg-Database
migration report?
-Pawan
On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver
wrote:
> On 05/29/2017 06:40 AM, PAWAN SHARMA wrote:
>
>>
>>
> ya, but how can fix it.??
>>
>> because memory is not an issue on both the server.
>>
>>
>> Hi Chris,
>>
>>
On Mon, May 29, 2017 at 6:54 PM, PAWAN SHARMA
wrote:
>
>
> On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote:
>
>> [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
>>> [>] 1/2 total rows (50.0%) - (4 sec., avg: 0
On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote:
> [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec)
>> [>] 1/2 total rows (50.0%) - (4 sec., avg: 0
>> recs/sec).
>> Out of memory!] 1/2 rows (50.0%) on total estimated data (4
>> sec., avg
On Mon, May 29, 2017 at 6:28 PM, Chris Mair wrote:
> C:\ora2pg>ora2pg -c ora2pg.conf
>> [>] 2/2 tables (100.0%) end of scanning.
>> [>] 0/2 tables (0.0%) end of scanning.
>> [>] 2/2 tables (100.0%) end of table export.
>>
>
>
On Mon, May 29, 2017 at 2:49 PM, Chris Mair wrote:
> I am facing below issue while running below command.
>>
>> *C:\ora2pg>ora2pg -c ora2pg.conf*
>> DBI connect('host=;sid=;port=',',...)
>> failed: ORA-01017: invalid username/p
>> assword; logon denied (DBD ERROR: OCISessionBegin) at
>> C:/Strawb
Hi All,
I am going to migrate Oracle database into PostgreSQL using ora2pg tools.
I have installed Strawberry Perl.
C:\ora2pg>perl -v
This is perl 5, version 24, subversion 1 (v5.24.1) built for
MSWin32-x64-multi-thread
Copyright 1987-2017, Larry Wall
I am facing below issue while running belo
Hi All,
Does one any having list of bottlenecks and workarounds while migrating data
from Oracle to Postgresql. like what are thing which we can migrate from
Oracle database to Postgresql and what we can't?
Which is the best tool for migration from Oracle to Postgresql?
-Pawan
be taken to prevent this ?
*Thanks & Regards,Pawan Sharma*
*+91-9899396940*
*Skpye ID: pawanshr.0963*
*Thinkā¦ before you print(Save Environment)*
Hi All,
I want to use pgsync method for LDAP configuration in current environment.
So please help me and share the document or link for configuration.
-Pawan
Hi All,
I want to use pgsync method for LDAP configuration in current environment.
So please help me and share the document or link for configuration.
-Pawan
On Fri, Feb 3, 2017 at 9:11 PM, Adam Brusselback
wrote:
> Whoops, accidentally sent this to only Pawan instead of the list:
>>
>>
> Hey there, so I would highly suggest you avoid arbitrary password strength
> policies like that. I wrote a library for my company which we use for
> password streng
On Fri, Feb 3, 2017 at 8:44 PM, PAWAN SHARMA
wrote:
> Hi All,
>
> Is this possible to create trigger in postgres to check the password
> strength( like char should be min 8 character) while to creating user or
> role with password.
>
> If it possible can you please sha
Hi All,
Is this possible to create trigger in postgres to check the password
strength( like char should be min 8 character) while to creating user or
role with password.
If it possible can you please share the script with me..
-Pawan
On Fri, Feb 3, 2017 at 12:47 AM, John R Pierce wrote:
> On 2/2/2017 11:09 AM, PAWAN SHARMA wrote:
>
>
> 1: Create User
> 2:Create group
> 3:Alter Group Add/Remove User's..
>
>
> create user user1;
> create user user2;
> create group group1;
&g
On Fri, Feb 3, 2017 at 12:08 AM, John R Pierce wrote:
> On 2/2/2017 8:24 AM, Moreno Andreo wrote:
>
>
> Can we use AD(Active Directory) groups concepts in postgres as we are
> using this concepts in SQL server.
>
> So, is there any possible to work with AD groups such as (IT-DBA,
> IT-APPS..etc )
Hi All,
Can we use AD(Active Directory) groups concepts in postgres as we are using
this concepts in SQL server.
So, is there any possible to work with AD groups such as (IT-DBA,
IT-APPS..etc ) in postgresql.
-Pawan
Hi All,
I have few question regarding Postgres security.
1. How can we set user account block feature after max number of
invalid password entries?
2. How can we use SSL encryption in Postgres on Linux environment?
3. How can we transparent data encryption in Postgres?
Thanks
Hello All,
I am new to postgres using OS: linux 7.2 and postgres : postgresql-9.5.4-2.
what are the factor's affecting postgres performance? and to overcome them.
Please suggest..!
*-Pawan*
Hi All,
I am using postgres 9.5 enterprise and if I want to move or upgrade it 9.6
enterprise version then what are steps required and is it done by any
patching or we have to completely upgrade from. 9.5 to 9.6
-Pawan
Hello All,
I am using postgres 9.5 enterprise edition.
i want to to how to migrate Sql Server database to PostgreSql. what are the
things required for migration and what are the cron and prons of migration.
-Pawan
nce B having 50 databases and I want to move
all databases running on instance A to another server having same postgres
version and server configuration.
So,please suggest how i can move instance A to another server.
On 18 Jan 2017 7:10 p.m., "Vick Khera" wrote:
> On Wed, Jan 18, 2017
Hello All,
I am using postgres 9.5 enterprise edition and postgres 9.5 open source
where i want know solution of two problems.
1.How can we restore single database from base backup files only, I don't
have pg_dump backup.
2.How can we restore single instance on different server where multiple
43 matches
Mail list logo