Re: [GENERAL] Postgres DB is failed due to pg_Xlog is continues full.

e know. Regards, Yogesh On Thursday, September 14, 2017, Michael Paquier wrote: > On Thu, Sep 14, 2017 at 12:44 PM, John R Pierce > wrote: > > prior to that error, something else catastrophic must have happened to > the > > system, that error is more of a side effect. r

Re: [GENERAL] Postgres DB is failed due to pg_Xlog is continues full.

Dear all, As current situation, i can not upgrade on higher version. Is there any recovery command available? Regards, Yogesh On Thursday, September 14, 2017, Gavin Flower wrote: > On 14/09/17 15:29, Yogesh Sharma wrote: > >> Dear All, >> >> Thanks in advance. >

Re: [GENERAL] Postgres DB is failed due to pg_Xlog is continues full.

directory has been continuously increased and directory has been full and Postgres is stopped. Please let me know how to recover this issue. Regards. Yogesh

Re: [GENERAL] Perl script is killed by SIGPIPE

is killed. On Tuesday, September 12, 2017, Daniel Verite wrote: > Yogesh Sharma wrote: > > > We have found child script is killed by signal 13 SIGPIPE. When duplicate > > key violates error occured, script is killed but not all time. > > "child script" a

[GENERAL] Perl script is killed by SIGPIPE

ot Comming every time. We have found child script is killed by signal 13 SIGPIPE. When duplicate key violates error occured, script is killed but not all time. Thanks in advance. Yogesh

Re: [GENERAL] Request to confirm which command is use for exclusive operation

Dear Albe, Thanks for your support. I observed there is some problem in REINDEX operation in older PostgreSQL versions. That why i want to add explicitly lock. Regards, Yogesh On Wednesday, March 8, 2017, Albe Laurenz wrote: > Yogesh Sharma wrote: > > I want to apply explic

Re: [GENERAL] Request to confirm which command is use for exclusive operation

Dear Scott, How to handle table with token? How to implement this? Regards, Yogesh On Wednesday, March 8, 2017, Scott Marlowe wrote: > On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe > wrote: > > On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma > wrote: > >> Dear Dav

Re: [GENERAL] Request to confirm which command is use for exclusive operation

Dear David, I want to apply explicitly lock mechanism once inset operation is in progress then REINDEX will wait. And vice versa. So, please let me know this type of handling is possible. Regrds, Yogesh On Wednesday, March 8, 2017, David G. Johnston wrote: > On Tuesday, March 7, 2017, Yog

[GENERAL] Request to confirm which command is use for exclusive operation

Dear all, Thanks for your support. I need to perfrom INSERT and REINDEX operation exclusively. For example: If REINDEX operation is in progress then INSERT operation will wait and vice versa. Please let me know if any approach is available. Regards, Yogesh sharma

Re: [GENERAL] Request to share approach during REINDEX operation

Dear Steven, Thanks for your reply. Yes. You are correct. Regards, Yogesh On Wednesday, December 21, 2016, Steven Winfield < steven.winfi...@cantabcapital.com> wrote: > > In my production system, there are lot of read write operation > performed every hour. > > > &g

Re: [GENERAL] Request to share approach during REINDEX operation

Dear Vick, I have responded on previously mail. In my production system, there are lot of read write operation performed every hour. Regards, yogesh On Wednesday, December 21, 2016, Vick Khera wrote: > On Wed, Dec 21, 2016 at 4:02 AM, Yogesh Sharma > wrote: > > Also, eve

Re: [GENERAL]

Dear All, I understood below point and i will do the same on my system. Can i close db session before REINDEX operation and again start db session after REINDEX completed? Regards, Yogesh On Wednesday, December 21, 2016, Jaime Soler wrote: > if you want to reduce the impact of reindex

Re: [GENERAL]

Dear Alban, In my production system, there are lot of read write operation performed every hour. So, i am thinking, if i can add check during REINDEX operation nothing update and insert operation performed. Is it possible? Regards, Yogesh On Wednesday, December 21, 2016, Alban Hertroys wrote

[GENERAL] Fwd: Request to share approach during REINDEX operation

reindex will not completed. Regards, Yogesh

[GENERAL]

. Regards, Yogesh

Re: [GENERAL] Query regarding deadlock

is possible? Regards, Yogesh -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Friday, November 25, 2016 10:55 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Query regarding deadlock On 11

[GENERAL] Query regarding deadlock

tion to resolve this deadlock. Regards, Yogesh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Request to share information regarding deadlock in postgresql-9.3.6

, roll_number varchar(20) not null, account_id varchar(20) not null default '-', - primary key (id, roll_number, account_id) How to resolve this issue? Regards, Yogesh -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...

[GENERAL] Request to share information regarding deadlock in postgresql-9.3.6

process has a lock on. Process 5764: INSERT INTO table2 ( id , roll_number, name) VALUES( '1', '4','abc' ) Process 4970: REINDEX TABLE table1, table2 etc.. How to resolve this problem? Regards, Yogesh -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Request to share information regarding errors

e_id. At this time, DB is shutdown. This shutdown is related to this error or not? Regards, Yogesh -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles Clavadetscher Sent: Wednesday, November 16, 2016 3:44 PM To: Yo

Re: [GENERAL] Request to share information regarding errors

n keys for referenced table "table2" alter table1 table_name add constraint fk_key foreign key (id, phone_id) references table2 (id, phone_id) on delete restrict on update restrict; Could you please share the details of these errors and how to resolve these errors from logs. Regard

Re: [GENERAL] Request to share information regarding deadlock in postgresql-8.1.18

e preventing checkpoints?what are the related checkpoint and WAL settings? Many WAL files are generated in pg_xlog directory. I don’t know how I can check checkpoint and WAL settings? By default setting of postgresql.conf is used. Regards, Yogesh -Original Message- From: pgsql-gene

[GENERAL] Request to share information regarding deadlock in postgresql-8.1.18

s link with WAL file of pg_xlog? Please share your opinion. Regards, Yogesh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] postgresql-8.1.18-2.1 information

Dear All, Thanks for your support. I need to take source rpm for below version for rhel. postgresql-8.1.18-2.1 Could you please share link, so that I will take. I have tried to search but could not found. Regards, Yogesh

Re: [GENERAL] Request to share information regarding postgresql pg_xlog file.

nitiated on file system. Thanks, Yogesh From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, September 15, 2016 1:24 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Request to share information regarding postgresql

Re: [GENERAL] Request to share information regarding postgresql pg_xlog file.

ter 60 sec. please confirm below message in postgre logs. FATAL: terminating connection due to administrator command Regards, Yogesh From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, September 15, 2016 11:28 AM

[GENERAL] Request to share information regarding postgresql pg_xlog file.

. FATAL: terminating connection due to administrator command Regards, Yogesh

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

understand the multiple version number which are mentioned before several patch at given link. https://bucardo.org/postgres_all_versions.html Please let me know what yours thought onto this. Regards, Yogesh From: David G. Johnston [mailto:david.g.johns...@gmail.com] Sent: Wednesday, June 15

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

s? 2. This changes are implemented only in above versions or is it propagated on every above newer versions after that? 3. Why same line is mentioned in the release notes of above 8.3.8,8.4.1,8.2.14 versions? Regards, Yogesh -Original Message- From: pgsql-general-ow...@postgresql.org [ma

[GENERAL] Changelog version from 8.1.2 to 9.3.6

Dear All, Thanks for your support. Could you please assist for changelog version option used to find the differences between the versions. In addition we required information of changes done in all releases from 8.1.2 to 9.3.6. Thanks in advance . Regards, Yogesh

Re: [GENERAL] Issue during postgresql startup

Dear All, Could you please update your suggestion on below mail Regards, Yogesh From: Yogesh Sharma Sent: Friday, April 29, 2016 3:57 PM To: John R Pierce; pgsql-general@postgresql.org Subject: RE: [GENERAL] Issue during postgresql startup Dear All, I am sharing my further observation

Re: [GENERAL] Issue during postgresql startup

tically. I’ll appreciate any kind of opinion on my understanding. Thanks, Yogesh Sharma From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, April 28, 2016 2:51 PM To: pgsql-general@postgresql.org Subject: Re: [GENER

Re: [GENERAL] Issue during postgresql startup

Dear John, >do you have backups from before this occurred ? No, there is no backup available for the same. Regards, Yogesh From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, April 28, 2016 2:18 PM To: pgsql-gene

Re: [GENERAL] Issue during postgresql startup

is that what you're running? We are running postgres 8.3. Regards, Yogesh From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, April 28, 2016 1:44 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Issue during

Re: [GENERAL] Issue during postgresql startup

iles in pg_xlog also increased abruptly from the same time when this error started coming. Is it related to above error ? Any help will be much appreciated ! Let me know if any other help is required. Thanks, Yogesh From: Sameer Kumar [mailto:sameer.ku...@ashnik.com] Sent: Thursday, April 28,

[GENERAL] Issue during postgresql startup

tried below procedure for the same but after recover this system, all DB tables are destroyed. http://www.hivelogik.com/blog/?p=513 Please let me know if any solution. Regards, Yogesh DISCLAIMER

[GENERAL] Select query regarding info

D-CONFORMING-STRINGS> With version 9.1 the default for this parameter was changed from off to on. Version 8.1 and later would emit a warning when you used the non-standard way of escaping single quotes (unless you explicitly turned that off) Could you please provide below inf

Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage

bpq.so.5.3 libpq.so.5 How to resolve by postgresql.spec file? Regards, Yogesh From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rob Sargent Sent: Wednesday, October 15, 2014 10:08 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Any pos

Re: [GENERAL] Help related to Postgresql for RHEL 6.5

Dear David, > Are you currently using PostgreSQL? Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8. Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in verion 9.0 I found least Compatibilities. So, please guide me. Regards, Yogesh -Original Mess

Re: [GENERAL] Help related to Postgresql for RHEL 6.5

Dear All, Compatibility issues of 9.3 are more. So, please guide which version is suitable. Regards, Yogesh -Original Message- From: Devrim Gündüz [mailto:dev...@gunduz.org] Sent: Thursday, August 28, 2014 7:34 PM To: Yogesh. Sharma Cc: pgsql-general@postgresql.org Subject: Re

[GENERAL] Help related to Postgresql for RHEL 6.5

Dear All, I want to upgrade RHEL 5.4 to RHEL 6.5. So, could you please let me know, which postgresql version is stable for RHEL 6.5? Regards, Yogesh DISCLAIMER: --- The

[GENERAL] Postgre Performance

re of queuing? Thanks Yogesh

Re: [GENERAL] Postgre Performance

Hello Raghavendra, Following are the details.. PostgreSQL9.0 , we running our application on 4CPU 8GB RAM system. Thanks Yogesh From: Raghavendra [mailto:raghavendra@enterprisedb.com] Sent: Tuesday, October 18, 2011 9:46 PM To: Deshpande, Yogesh Sadashiv (STSD-Openview) Cc: pgsql-general

Re: [GENERAL] Postgre Performance

I am not able to find binary distribution of pgbouncer for windows.. Can you point me to the location? From: Raghavendra [mailto:raghavendra@enterprisedb.com] Sent: Tuesday, October 18, 2011 10:33 PM To: Bill Moran Cc: Deshpande, Yogesh Sadashiv (STSD-Openview); pgsql-general@postgresql.org

[GENERAL] Seeking for vacuum advise

Hello, We are using postgres for one of our application. Currently using Postgres 8.3 with CentOS 5.3 x86_64 We are using inherited tables. Base table has 3 columns: entry_date timestamp with time zone nametext valuetext pk is timestamp data tables are derived from this base table wit

[GENERAL] how to create cluster(loadbanacing) of postgresql server

Hi FriendsCan any Guys help me to create postgresql Cluster.Is there any useful link or Info.  related to cluster than pl mail me. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

Re: [GENERAL] Number to Words Conversion

ash_words('1520'), 1, position('dollars' in > cash_words('1520'))-1)); > > will return you > > One thousand five hundred twenty (But ofcourse this eg. does not work for > decimals) > > Regards, > Moiz Kothari > > On 11/2/07, Bruce Momjian &l

[GENERAL] Number to Words Conversion

Hello Frnds, Is there any way to Convert the Number to its equivalent String ( Words) e.g. 10 to TEN. Urgent require the Answer.. Regards, Yogesh Arora ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

[GENERAL] Postgres SQL Client for Suse Linux

Hello Frnds, I have installed postgres on Suse Linux using the YAST-->Software. I have to check and Manipulate the tables and check the data..is there are any client application to work on the Suse Linux. Regards, Yogesh Arora. ---(end of broadc