>>What you could do is copying its contents to a large disk, and then allow
it to recover from the crash.
I will copy the PGDATA into large disk. After that it is require to
execute some specific command or automatically recovery will start?
If any command is require to execute please let me
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 <gavinflo...@archidevsys.co.nz>
wrote:
> On 14/09/17 15:29, Yogesh Sharma wrote:
>
>> Dear All,
>&
Dear All,
Thanks in advance.
We are using Postgres 8.1.18 version.
In Postgres log, we found below logs.
–-
CONTEXT:writing block 0 of relation 1664/0/1260
ERROR: could not write block 0 of relation 1664/0/1260: Bad address
Due to this pglog_Xlog
ipt is killed.
On Tuesday, September 12, 2017, Daniel Verite <dan...@manitou-mail.org>
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.
>
>
> Dear All,
We have one perl script that is opening DB connection and performaing
insert DB operation.When duplicate entry Comming in query,Postgres
forecfully killing process itself and in Postgres log "unexpected EOF on
client connection" error is Comming.
This issue is not Comming every
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 <laurenz.a...@wien.gv.at> wrote:
> Yogesh Sharma wrote:
&g
n Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma <yogeshra...@gmail.com
> <javascript:;>> wrote:
> >> Dear David,
> >>
> >> I want to apply explicitly lock mechanism once inset operation is in
> >> progress then REINDEX will wait.
> >>
wrote:
> On Tuesday, March 7, 2017, Yogesh Sharma <yogeshra...@gmail.com
> <javascript:_e(%7B%7D,'cvml','yogeshra...@gmail.com');>> wrote:
>
>> Dear all,
>>
>> Thanks for your support.
>>
>> I need to perfrom INSERT and REINDEX operation exclusivel
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
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.
>
>
>
> Apologies if this sounds
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 <vi...@khera.org> wrote:
> On Wed, Dec 21, 2016 at 4:02 AM, Yogesh Sharma <yogeshra.
>
>
> 2016-12-21 12:51 GMT+01:00 Yogesh Sharma <yogeshra...@gmail.com
> <javascript:_e(%7B%7D,'cvml','yogeshra...@gmail.com');>>:
>
>> Dear Alban,
>>
>> In my production system, there are lot of read write operation performed
>> every hour.
>&
ram...@gmail.com> wrote:
> On 21 December 2016 at 09:59, Yogesh Sharma <yogeshra...@gmail.com
> <javascript:;>> wrote:
> > Also, every hour,i am performing VACUUM and REINDEX operation on table.
>
> Why are you running REINDEX every hour? That's a very unusual thi
Adding subject line
Dear All,
Thanks for your support.
I am using postgresql 9.3.6 on RHEL6.6 machine.
In my production environment, Some script are executing automatically
through cron.
These script are performing insert and update operation.
Also, every hour,i am performing VACUUM and
Dear All,
Thanks for your support.
I am using postgresql 9.3.6 on RHEL6.6 machine.
In my production environment, Some script are executing automatically
through cron.
These script are performing insert and update operation.
Also, every hour,i am performing VACUUM and REINDEX operation on table.
/24/2016 5:44 PM, Yogesh Sharma wrote:
> I cannot change calling of REINDEX and insert query sequence because it is
> execute automatically through some cron script.
any cron scripts are your own doing, so this statement makes no sense at all.
--
john r pierce, recycling bits in sant
Dear All,
Thanks in advance.
I found below deadlock in postgresql logs.
I cannot change calling of REINDEX and insert query sequence because it is
execute automatically through some cron script.
ERROR: deadlock detected
DETAIL: Process 2234 waits for AccessShareLock on relation 16459 of
l.org] On Behalf Of John R Pierce
Sent: Thursday, November 17, 2016 12:04 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request to share information regarding deadlock in
postgresql-9.3.6
On 11/16/2016 6:22 PM, Yogesh Sharma wrote:
> process 5764 is waiting for relation (table
Dear All,
Thanks for your support.
Could you please share your opinion for deadlock resolution.
Process 5764 waits for AccessShareLock on relation 16459 of database 16385;
blocked by process 4970.
Process 4970 waits for ShareLock on relation 16502 of database 16385; blocked
by process 5764.
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
Dear All,
Thanks for your support.
I am using postgresql 9.3.6 rpm in RHEL6 version.
In postgresql logs, I have found below error messages.
ERROR: null value in column "column name" violates not-null constraint.
Second error found:
ERROR: there is no unique constraint matching given keys for
ral-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Monday, November 14, 2016 4:19 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request to share information regarding deadlock in
postgresql-8.1.18
On 11/13/2016 11:01 PM, Yogesh Sharma w
Dear All,
Thanks in advance.
In my Linux system, below error is found and after 10~12 hours, WAL file in
pg_xlog directory are increased continuously.
PostgreSQL:ERROR: deadlock detected
DETAIL: Process 12345 waits for AccessShareLock on relation 16446 of database
16385; blocked by process
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
pg_xlog file.
On 9/15/2016 12:25 AM, Yogesh Sharma wrote:
Dear John,
Thanks for your support.
Please find below name of rpm.
RPMS/postgresql-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-devel-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-libs-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-python-8.1.18-2.1.x86_64.rpm
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request to share information regarding postgresql
pg_xlog file.
On 9/14/2016 10:09 PM, Yogesh Sharma wrote:
Thanks for your support and suggestion.
We are using below postgresql rpm.
postgresql-8.1.18-2.1
thats not the full RPM name, thats just the
Dear Team,
Thanks for your support and suggestion.
We are using below postgresql rpm.
postgresql-8.1.18-2.1
In our system, below error is found and occurring is very frequent.
CONTEXT: writing block 53 of relation 1663/16385/280951
ERROR: could not open relation 1663/16385/280951: No such
, 2016 7:18 PM
To: Albe Laurenz
Cc: Yogesh Sharma; Adrian Klaver; Moreno Andreo; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6
On Wed, Jun 15, 2016 at 3:31 AM, Albe Laurenz
<laurenz.a...@wien.gv.at<mailto:laurenz.a...@wien.gv.at>> wrote:
Yogesh
s://www.postgresql.org/docs/9.3/static/release.html
>
> you can find all release notes, including changelogs for all versions.
Also a one page version:
https://bucardo.org/postgres_all_versions.html
>
> HTH,
> Moreno.
>
> Il 10/06/2016 13:17, Yogesh Sharma ha scritto:
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
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
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
ral@postgresql.org
Subject: Re: [GENERAL] Issue during postgresql startup
On 4/28/2016 1:33 AM, Yogesh Sharma wrote:
>did you get that 'no such file or directory' error before or after you reset
>the transaction logs ?
The error message is coming before.
that means your file system l
tup
On 4/28/2016 12:21 AM, Yogesh Sharma wrote:
Could you please tell me, how to recover my system.
I am facing below errors.
---
could not open relation 1663/16385/1299988: No such file or directory
---
This message is continuous occurred in s
8, 2016 1:45 PM
To: Yogesh Sharma; pgsql-general
Subject: Re: [GENERAL] Issue during postgresql startup
On Thu, 28 Apr 2016 15:22 Yogesh Sharma,
<yogesh1.sha...@nectechnologies.in<mailto:yogesh1.sha...@nectechnologies.in>>
wrote:
Dear All,
Thanks for your support.
Could you please
Dear All,
Thanks for your support.
Could you please tell me, how to recover my system.
I am facing below errors.
---
could not open relation 1663/16385/1299988: No such file or directory
---
This message is continuous occurred in system .
I have
HI Everyone,
Below DB query is showing below error on postgresql9.3.
SELECT '\'' || t2.name || '\'', '\'' || t1.phone_number || '\'', '\'' ||
t1.details || '\'', '\'' || t1.description || '\'', '\'' || (CASE WHEN t1.s_id
IS NULL THEN 'N/A' ELSE t3.s_type END) || '\'', '\'' || t1.s_id || '\''
Dear All,
I am facing some issue during postgresql service stop.
Issue:-
[root@localhost postgresql-9.0.18]# runuser -l postgres -c
'/usr/pgsql/bin/pg_ctl stop -D '\''/var/lib/pgsql/data'\'' -s -m fast'
/usr/pgsql/bin/pg_ctl: error while loading shared libraries: libpq.so.5: cannot
open shared
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
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
-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston
Sent: Friday, August 29, 2014 9:22 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help related to Postgresql for RHEL 6.5
Yogesh. Sharma wrote
Compatibility issues of 9.3
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
42 matches
Mail list logo
