Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres

On Fri, Feb 3, 2017 at 12:47 AM, John R Pierce <pie...@hogranch.com> 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; &

Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres

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

[GENERAL] LDAP configuration

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

[GENERAL] AD(Active Directory) groups concepts in postgres

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

Re: [GENERAL] create trigger in postgres to check the password strength

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

[GENERAL] create trigger in postgres to check the password strength

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

Re: [GENERAL] create trigger in postgres to check the password strength

On Fri, Feb 3, 2017 at 8:44 PM, PAWAN SHARMA <er.pawanshr0...@gmail.com> 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

[GENERAL] Doubts regarding postgres Security

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

[GENERAL] Fwd: LDAP configuration

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

[GENERAL] Restore single databaseR

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

[GENERAL] Moving from 9.5 to 9.6

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

Re: [GENERAL] Restore single databaseR

, Jan 18, 2017 at 7:32 AM, PAWAN SHARMA <er.pawanshr0...@gmail.com> > wrote: > >> 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 si

[GENERAL] migrate Sql Server database to PostgreSql

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

[GENERAL] factor effecting performance of postgres

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*

Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

On Wed, Jul 26, 2017 at 11:36 PM, <kbran...@pwhome.com> wrote: > On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA <er.pawanshr0...@gmail.com> > wrote: > > > > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier < > michael.paqu...@gmail.com> wrote: > > O

[GENERAL] getting error while parsing log file using pgbadger

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

Re: [GENERAL] monitoring PostgreSQL

On Mon, Jul 24, 2017 at 5:50 PM, PAWAN SHARMA <er.pawanshr0...@gmail.com> wrote: > > On Mon, Jul 24, 2017 at 5:20 PM, Tim Clarke <tim.cla...@manifest.co.uk> > wrote: > >> We use nagios for all alerting, it'll do what you need. >> >> Tim Clarke >> &

Re: [GENERAL] monitoring PostgreSQL

On Mon, Jul 24, 2017 at 7:28 PM, Tim Clarke <tim.cla...@manifest.co.uk> wrote: > > > On 24/07/17 14:47, PAWAN SHARMA wrote: > > > > Hi Tim, > > > > Facing below issue > > > > [abc@test:/home/psharm89/nrpe-2.15]# > > Redirecting to /bi

Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

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 > <er.pawanshr0...@gmail.com> wrote: > > > > Hi All, > > > > I am facing below error while parsing log file. > >

Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA <er.pawanshr0...@gmail.com> 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 >> <er.pawanshr0...@gmail.com&g

Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger

On Wed, Jul 26, 2017 at 5:38 PM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Wed, Jul 26, 2017 at 2:01 PM, PAWAN SHARMA <er.pawanshr0...@gmail.com> > wrote: > > For root user its working fine > > > > [root@abc :/opt/PostgreSQL/9.5/data/pgaudit]#

[GENERAL] Fwd: getting error while parsing log file using pgbadger

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

Re: [GENERAL] monitoring PostgreSQL

exactly at > > the system 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

[GENERAL] monitoring PostgreSQL

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

[GENERAL] How to install pgadmin3 or pgadmin4 on linux machine

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

Re: [SPAM] [GENERAL] How to install pgadmin3 or pgadmin4 on linux machine

On Jul 5, 2017 17:40, "Moreno Andreo" <moreno.and...@evolu-s.it> 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

Re: [SPAM] [GENERAL] How to install pgadmin3 or pgadmin4 on linux machine

On Wed, Jul 5, 2017 at 6:29 PM, Adrian Klaver <adrian.kla...@aklaver.com> 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 >

[GENERAL] Cookbook for doing installation and configuration of PostgreSQL on Redhat

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

[GENERAL] PostgreSQL Cookbook Testing

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

Re: [GENERAL] PostgreSQL Cookbook Testing

On Fri, Jun 23, 2017 at 6:10 PM, Karsten Hilbert <karsten.hilb...@gmx.net> 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. > > > > #-> kitch

Re: [GENERAL] Oracle to PostgreSQL Migration.

On Mon, May 29, 2017 at 6:54 PM, PAWAN SHARMA <er.pawanshr0...@gmail.com> wrote: > > > On Mon, May 29, 2017 at 6:51 PM, Chris Mair <ch...@1006.org> wrote: > >> [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) >>> [>

Re: [GENERAL] Oracle to PostgreSQL Migration.

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

Re: [GENERAL] Oracle to PostgreSQL Migration.

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

Re: [GENERAL] Oracle to PostgreSQL Migration.

On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver <adrian.kla...@aklaver.com> 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. >> >> &g

[GENERAL] Oracle to PostgreSQL Migration.

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

Re: [GENERAL] Oracle to PostgreSQL Migration.

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:

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

On Fri, Jun 2, 2017 at 2:13 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hi > > 2017-06-02 10:16 GMT+02:00 PAWAN SHARMA <er.pawanshr0...@gmail.com>: > >> Hi All, >> >> I am migrating Oracle database into PostgreSQL using Ora2PG tool. >>

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

w Sullivan > Please excuse my clumbsy thums. > > On Jun 2, 2017, at 04:16, PAWAN SHARMA <er.pawanshr0...@gmail.com> wrote: > > Hi All, > > I am migrating Oracle database into PostgreSQL using Ora2PG tool. > > So, I am facing one issue with trigger after generating scrip

[GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

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

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

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

[GENERAL] Vaccum Query

be taken to prevent this ? *Thanks & Regards,Pawan Sharma* *+91-9899396940* *Skpye ID: pawanshr.0963* *Think… before you print(Save Environment)*

[GENERAL] Migration Query

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

[GENERAL] Ora2Pg-Database migration report

Hi All, What is the formula to calculate estimated cost in Ora2Pg-Database migration report? -Pawan