[GENERAL] Schema (Search path issue) on PostgreSQL9.2

Hi All, I have seen strange behaviour in PostgreSQL9.2 version,it has been allowing to set search path any name,even the name is not created as a schema in database. Please find the below case between PostgreSQL9.1 and PostgreSQL9.2. *PostgreSQL9.2:* + postgres=# select version();

Re: [GENERAL] DELETE or TRUNCATE?

Hi, Yes,DELETE would be better this case. The TRUNCATE operation required AccessExclusiveLock on Table before perform TRUNCATE operation. So,if you the table size is bing,it is batter to do ANALYZE Table after report and VACUUM table non-peak(less business) hours. Regards, Chiru On Thu, May

Re: [GENERAL] About replacing PostgreSQL instance

Hi Oscar Calderon, Replacing instance is not good approach in major version (from PG9.1 to 9.3). Yes,your approach is correct it should be upgrade,since it is production need to take some extra care. On Thu, May 16, 2013 at 11:49 PM, Oscar Calderon ocalde...@solucionesaplicativas.com wrote:

Re: [GENERAL] error postgresql remote access windows 7

Arvind, It seems this is Firewall issue.Server side(where as postgresql installed) port(Ex:5432 default) was not opened to access postgres instance from client machines. please stop firewalls on windows 7 machine and try to connect from client machine. Best Regards, Chiru On Mon, May 27, 2013

[GENERAL] Facing difficulty in PITR

Hello, We are facing difficulty in PITR. *Case :* Production server backups are happening every day at 12:00AM mid night and we are refreshing Test server with the backup and applying wal archives up to 10:00AM. *Issue:* * * While transferring wal archives from Production to Test server,

Re: [GENERAL] Facing difficulty in PITR

Thanks Jerry,it worked for me and saved my time. Regards, Chiru On Wed, Apr 10, 2013 at 4:57 AM, Jerry Sievers gsiever...@comcast.netwrote: chiru r chir...@gmail.com writes: Hello, We are facing?difficulty?in PITR. Case : Production server backups are happening every day at 12

Re: [GENERAL] To monitor the number of PostgreSQL database connections?

And also you can monitor by scheduling below command in cron. It will collect the detailed data, so that we came to know where the connections are coming. [postgres@local~]$ crontab -l * * * * * /opt/postgres/9.3/bin/psql -Aqt -p 5493 -c select * from pg_stat_activity; /tmp/stats.csv On Thu,

[GENERAL] lpgport issue while installing pg_bulkload utility on fedora 14 OS

Hi, I am facing below *-lpgport *issue while installing pg_bulkload utility on fedora 14 OS. Details: *OS* : *Fedora 14* Linux localhost.localdomain 2.6.35.6-45.fc14.x86_64 #1 SMP Mon Oct 18 23:57:44 UTC 2010 x86_64 x86_64 x86_64 GNU/Linux *PG* : PostgreSQL 8.4.9 *pg_bulkload* 3.1.4

Re: [GENERAL] lpgport issue while installing pg_bulkload utility on fedora 14 OS

]# On Mon, Apr 14, 2014 at 7:10 PM, Adrian Klaver adrian.kla...@aklaver.comwrote: On 04/14/2014 06:21 AM, chiru r wrote: Hi, I am facing below *-lpgport *issue while installing pg_bulkload utility on fedora 14 OS. Details: *OS* : *Fedora 14* Linux localhost.localdomain 2.6.35.6-45

Re: [GENERAL] lpgport issue while installing pg_bulkload utility on fedora 14 OS

* Is there any workaround. On Mon, Apr 14, 2014 at 8:23 PM, Adrian Klaver adrian.kla...@aklaver.comwrote: On 04/14/2014 07:21 AM, chiru r wrote: Actually Just what the docs say: http://pgbulkload.projects.__pgfoundry.org/pg_bulkload.__html#install http://pgbulkload.projects.pgfoundry.org

Re: [GENERAL] what should be the best autovacuum configuration for daily partition table

Hi Rumman, Please publish the below information. 1. vacuum and auto-vacuum parametters current settings on cluster. select name,setting from pg_settings where name ilike '%vacuum%'; 2. show maintenance_work_mem ; show autovacuum_max_workers ; 3. Physical Ram size on server. --Chiru

Re: [GENERAL] Backups over slave instead master?

Hi , Yes, It is possible to execute backups on the slave server instead of master. Below are the steps we run for one of our past customer every day to refresh his Dev/test environments using slave backups. *On Slave:* 1. Pause the replication postgres=# select pg_xlog_replay_pause();

Re: [GENERAL] help troubleshooting invalid page header error

Hi Cory, We have *zero_damaged_pages* parameter in PostgreSQL configuration,by default it is set be *off*. To recover data from corrupted table,we can turn *on* this parameter as a super user and populate new table using dump or copy utility. Note : The damaged pages we can't recover from

Re: [GENERAL] help troubleshooting invalid page header error

Hi Cory, After recovering table turn off *zero_damaged_pages *parameter. On Fri, Dec 26, 2014 at 9:13 PM, Cory Zue c...@dimagi.com wrote: Hi all, Thanks for the responses. Chiru, I'm looking into your suggestion. Sameer, here is the kernel version info: Linux dimagi

Re: [GENERAL] Streaming replication stacked.

Hi Yoji, Please check is there any network issues ,between master and slave server and also share the slave server pg log output. -Are you shipping wals to standby server using any script other than archive_command which is mentioned master config?. On Mon, Jan 4, 2016 at 5:58 PM, Andreas

Re: [GENERAL] Happy New Year

Happy New Year to all! On Fri, Jan 1, 2016 at 10:35 PM, Dorian Hoxha wrote: > Happy Holidays! > > Let's have automatic sharding and distributed transactions! > > On Fri, Jan 1, 2016 at 3:51 PM, Melvin Davidson > wrote: > >> Happy New Year to all!

Re: [GENERAL] pg_basebackup issue

(Which we are not interested in). In future is there possibility to allow a user(using above steps) to do pg_basebackup?. Thanks, Chiru On Sun, Apr 23, 2017 at 12:10 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 04/22/2017 08:04 PM, chiru r wrote: > >> Use cas

[GENERAL] pg_basebackup issue

Hello, I am using Postgresql 9.5 and I have created* backup_admin* user and created *dba_admin *ROLE with SUPERUSER and REPLICATION ,after that GRANT *dba_admin * role to backup_admin user and executed pg_basebakup utility with backup_admin user. But I am not able to use the pg_basebackup

Re: [GENERAL] pg_basebackup issue

any Issues/changes in pg_basebackup? Please provide your inputs. Thanks, Chiru On Sat, Apr 22, 2017 at 5:38 AM, John R Pierce <pie...@hogranch.com> wrote: > On 4/22/2017 2:28 AM, chiru r wrote: > > I am using Postgresql 9.5 and I have created* backup_admin* user and > created *db

Re: [GENERAL] pg_basebackup issue

22, 2017, chiru r <chir...@gmail.com> wrote: > >> Thank you for the reply. >> >> It is inheriting role attributes. I am able to do CREATEDB,CREATEROLE... >> etc . >> Even i am able to do manual start backup and stop backup also using >> *backup_adm

Re: [GENERAL] pg_basebackup issue

kla...@aklaver.com> wrote: > On 04/22/2017 08:13 AM, chiru r wrote: > >> But, SUPERUSER privileges are working, you can see above I am able to do >> CREATEUSER and CREATEDB. >> >> What is the differences in case A and case B for Superuser? >> > > I had f

Re: [GENERAL] pg_basebackup issue

to server: FATAL: must be superuser or replication role to start walsender* On Sat, Apr 22, 2017 at 2:00 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 04/22/2017 10:04 AM, chiru r wrote: > >> Thanks for the reply, >> >> Actually I am not setting Role f

Re: [GENERAL] pg_basebackup issue

ay, April 22, 2017, chiru r <chir...@gmail.com> wrote: > >> Thank you Adrian. >> >> It seems the code is allowing only who has Superuser/Replication role >> directly. >> >> Is there any possibility in future releases they allow both case A & B >

Re: [GENERAL] pg_basebackup issue

aver <adrian.kla...@aklaver.com> wrote: > On 04/22/2017 12:56 PM, chiru r wrote: > >> Thanks you. The FATAL message is not clear. Yes, It is helpful >> if someone with more knowledge of the connection code. >> > > Well if your interested in looking for yourse

Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2

, Chiru On Mon, Apr 24, 2017 at 12:29 PM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Mon, Apr 24, 2017 at 9:41 AM, chiru r <chir...@gmail.com> wrote: > > Hello, > > > > I am building new server to run PostgreSQL 9.5.4 version on it. Please > > provi

[GENERAL] Block size recommendation for Red Hat Linux 7.2

Hello, I am building new server to run PostgreSQL 9.5.4 version on it. Please provide the recommended Block size for Linux systems. We are using PostgreSQL blocks size is 8k default one. postgres=# show block_size ; block_size 8192 (1 row) Is there any recommendation for

[GENERAL] Access Management question

Hi All, I have a question about access management in PostgreSQL , please help me to understand. I am creating a role dba_admin with superuser role. after that created a user scott and then granted dba_admin role to user scott. postgres=# create role dba_admin superuser; CREATE ROLE postgres=#

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

On Tue, Sep 19, 2017 at 3:09 PM, Bruce Momjian <br...@momjian.us> wrote: > On Tue, Sep 19, 2017 at 01:28:11PM -0400, Stephen Frost wrote: > > Tom, > > > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > > chiru r <chir...@gmail.com> writes: > > >

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

, 2017 at 3:45 PM, John R Pierce <pie...@hogranch.com> wrote: > On 9/19/2017 12:33 PM, chiru r wrote: > >> Yes, LDAP will do. However we need to sync the user accounts and groups >> between AD and PG servers.and then AD profiles will apply to PG user >> accounts for aut

[GENERAL] USER Profiles for PostgreSQL

Hi All, Good Morning. We are looking for User profiles in ope source PostgreSQL. For example, If a user password failed n+ times while login ,the user access has to be blocked few seconds. Please let us know, is there any plan to implement user profiles in feature releases?. Thanks,

[GENERAL] SAP Application deployment on PostgreSQL

Hi All, We have multiple SAP applications running on Oracle as backend and looking for an opportunity to migrate from Oracle to PostgreSQL. Has anyone ever deployed SAP on PostgreSQL community edition? Is PostgreSQL community involved in any future road-map of SAP application deployment on

[GENERAL] Client Authentication methods

Hi All, I am trying to understand the Authentication method in pg_hba.conf file (password & md5) in PostgreSQL database server. I am assuming that the user provides the connection string host/usser/password,then client will go and contact the DB server pg_hba.conf file in memory without

[GENERAL] SSL and Encryption

Hi , Please suggest the best chiper suite to configure openSSL for PostgreSQL Server and client?. How to use other than md5 encryption algorithm to encrypt the passwords in PostgreSQL? Thanks, Chiru

[GENERAL] OpeSSL - PostgreSQL

Hi All, I am using PostgreSQL version *9.5.7* on Red hat enterprise Linux *7.2.* *OpenSSL version : * OpenSSL 1.0.1e-fips 11 Feb 2013. I have a requirement to enable the SSL in my environment with specific cipher suites,we want to restrict weak cipher suites from open SSL default list. We have

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

Thanks. If OpenSSL apply any patches at OS level, Is there any changes/maintenance we need to perform at PostgreSQL end? On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway <m...@joeconway.com> wrote: > On 11/09/2017 01:59 PM, chiru r wrote: > > I am using PostgreSQL version *9.