Hi,
I need to delete following threads posted by me on postgreSQL forum,
Kindly suggest me a way forward as it is urgent.
http://www.postgresql.org/message-id/84bc7ab0d621a74893ec9c9e151293b022685...@esessmb207.ericsson.se
http://osdir.com/ml/postgresql-pgsql-general/2015-04/msg00543.html
http
...@aklaver.com]
Sent: July 15, 2015 6:26 PM
To: Mitu Verma; pgsql-general@postgresql.org
Subject: Re: [GENERAL] unexpected data beyond EOF in block 260 of relation
pg_tblspc
On 07/15/2015 02:54 AM, Mitu Verma wrote:
> Just to add few more words to the queries mentioned be
Just to add few more words to the queries mentioned below -
_
From: Mitu Verma
Sent: July 15, 2015 11:15 AM
To: 'pgsql-general@postgresql.org'
Subject: RE: unexpected data beyond EOF in block 260 of relation pg_tblspc
Hi team,
kindly help m
Hi team,
kindly help me with the below query-
Below alarm was raised at the system where postgres database was used..
---
BGWPOL22-00:/var/opt/mediation/MMStorage6/Server8/CXC1734739_R8J/stora
Hi,
Below alarm was raised at the system where postgres database was used..
---
BGWPOL22-00:/var/opt/mediation/MMStorage6/Server8/CXC1734739_R8J/storage/logging/ACTIVE#
cat AA::80165730a!
1434
index"’ message is coming in the logs ?
Any leads?
Regards
Mitu
From: Pete Hollobon [mailto:postg...@hollobon.com]
Sent: May 27, 2015 3:04 PM
To: Albe Laurenz
Cc: Mitu Verma; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Re: duplicate key value violates unique constraint
"pg_class_relname
HI,
Following error is continuously seen with the postgreSQL database which we are
using at customer site.
Current Errors observed:
./fm_db_VoiceReprocessing1/data/pg_log/postgresql-04.log:2015-04-04 01:00:16
CESTERROR: duplicate key value violates unique constraint
"pg_class_relname_nsp_inde
"cdrlogentry" CONSTRAINT "cdrlogentry_audittableindex_fkey" FOREIGN
KEY (audittableindex) REFERENCES audittraillogentry(tableindex)
Has OIDs: no
Tablespace: "mmdata"
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: May 03, 2015 9:43
Hi,
I am facing an issue with the deletion of huge data.
We have a cronscript which is used to delete the data of last 3 months from one
of the tables.
Data in the table is large (8872597 as you can see the count below) since it is
from last 3 months.
fm_db_Server3=# select count(*) from auditt
can I
completely refresh the database session and run the delete command on the
table?
Regards
Mitu
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: April 29, 2015 6:40 PM
To: Mitu Verma; 'pgsql-general@postgresql.org' (pgsql-general@postgresql.
@s3bgwa31 # select count(*) from audittraillogentry ;
root@s3bgwa31 # psql -d fm_db_Server3 -p 5434 -U mmsuper
root@s3bgwa31 # ps -efa| grep -i delet
root 8985 8498 0 13:11:18 pts/3 0:00 grep -i delet
root@s3bgwa31 #
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-
Hi,
I am new to postgreSQL and facing an issue with the transactions which are
being shown in pg_locks.
We are using a script which deletes entries from a table called
audottrailLogEntry table.
This script first does the indexing then it deletes the entries from the table.
Now issue is that th
Hi,
We have a customer complaining about the time taken by one of the application
scripts while deleting older data from the log tables.
During the deletion, customer reported that he often sees the below error and
because of which table size doesn’t reduce.
ERROR: canceling autovacuum task
Dat
Correcting the subject
From: Mitu Verma
Sent: March 26, 2015 9:28 AM
To: pgsql-general@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Populating missing dates in postgresql data
Hi,
We have a customer complaining about the time taken by one of the application
scripts
What could be the possible impacts of leap second on June 30 2105 (which will
make the one second longer time) at PostgreSQL database ?
Regards
15 matches
Mail list logo
