Hi all,
Please let me know the latest PostgreSQL version available on Solaris 11?
Which PostgreSQL version will be supported on Solaris 11.x version and when the
same will be available ?
Regards
Tarkeshwar
Hi All,
In our production setup we found new issue as postgreSQL.conf has become zero
byte file.
After some time we copied that file from some back up, after some time it has
again become zero byte.
Any clue what is the reason of this behavior.
Regards
Tarkeshwar
Hi,
one thing in oracle is there any difference between "DROP PRIMARY KEY" used
directly in oracle to drop primary key, or "DROP CONSTRAINT CDRAUDITPOINT_pk",
as first syntax is not available in postgres and we need to give primary key
name as constraint to delete a key. SO right now to delete
Hi all,
We have started to convert some oracle sql scripts and converting them to
postgres, but facing some issues to create table.
I have some common doubts in create table script ie.
ALTER TABLE employee
DROP PRIMARY KEY CASCADE;
DROP employee CASCADE CONSTRAINTS;
CREATE TABLE employee
(
Hi all,
We have a table name auditTrailLogEntry where we were not able to able to
insert in auditTrailLogEntry table.
we have reindex the table and insertion issue has been resolved .
we executed following command:
Audit tail insertion issue.
INSERT INTO auditTrailLogEntry (event, inNodeID, i
20:16
To: M Tarkeshwar Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] can you have any idea about toast missing chunk issu
resolution
M Tarkeshwar Rao writes:
> ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
What PG version is that exactly?
If you
Hi all,
We are getting following error message on doing any action on the table
like(Select or open from pgadmin).
Please suggest.
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
** Error **
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_
19, 2014 5:16 PM
To: M Tarkeshwar Rao; pgsql-general@postgresql.org
Subject: Re: [GENERAL] can you please share sample Postgres config file to
enable max logging with syslog support?
On 12/18/2014 09:00 PM, M Tarkeshwar Rao wrote:
Hello friends,
can you please share sample Postgres config file
Hello friends,
can you please share sample Postgres config file to enable max logging with
syslog support?
Actually we are facing some issues. We need to enable maximum logging.
Regards
Tarkeshwar
Is column size less than 8 kb will help us?
-Original Message-
From: M Tarkeshwar Rao
Sent: 10 December 2014 11:51
To: 'Adrian Klaver'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] FW: getting error while running sql on mm_activealrm
table
Hi all,
-
From: M Tarkeshwar Rao
Sent: 04 December 2014 17:32
To: M Tarkeshwar Rao; Adrian Klaver; pgsql-general@postgresql.org
Subject: RE: [GENERAL] FW: getting error while running sql on mm_activealrm
table
Hi all,
Finally DB was restored from the backup and the issue was solved.
Is the data
Tarkeshwar
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of M Tarkeshwar Rao
Sent: 04 December 2014 16:38
To: Adrian Klaver; pgsql-general@postgresql.org
Subject: Re: [GENERAL] FW: getting error while running sql on
: M Tarkeshwar Rao; pgsql-general@postgresql.org
Subject: Re: [GENERAL] FW: getting error while running sql on mm_activealrm
table
On 12/03/2014 03:07 AM, M Tarkeshwar Rao wrote:
> Hi all,
>
> We are getting following error message on doing any action on the
> table like(Select
laver [mailto:adrian.kla...@aklaver.com]
Sent: 03 December 2014 20:22
To: M Tarkeshwar Rao; pgsql-general@postgresql.org
Subject: Re: [GENERAL] FW: getting error while running sql on mm_activealrm
table
On 12/03/2014 03:07 AM, M Tarkeshwar Rao wrote:
> Hi all,
>
> We are getting following er
Hi all,
We are getting following error message on doing any action on the table
like(Select or open from pgadmin).
Please suggest.
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619
** Error **
ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2
Hi all,
I installed version 9.1 in my Ubuntu OS, but not able to login.
What is default password for user Postgres?
Regards
Tarkeshwar
Hi all,
We are facing following issue in postgresql 9.1.3 in using arrow key in Solaris
platform.
Can you please help us to resolve it or any new release has fix for this or any
workaround for this?
issue: psql client generates a core when up arrow is used twice.
Platfrom: Solaris
Thanks for reply. We tried it but it is creating blank log file on pg_log.
From: Soni M [mailto:diptat...@gmail.com]
Sent: 13 August 2014 15:02
To: M Tarkeshwar Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Can I see the detailed log of query fired by particular
Postgres client on
Hi all,
Can I see the detailed log of query fired by particular Postgres client on
Postgres server?
This client might be any java application or any console Postgres client.
I want this for our debugging purpose.
Regards
Tarkeshwar
enewalflag| character varying(100) |
insuffbalflag | character varying(100) |
unsubscribeoninsufflag | character varying(100) |
preexpiryduration | character varying(10) |
Regards,
M Tarkeshwar Rao
Hi Asif,
Is it always creating core files on /var/lib/postgresql/8.4/main path for
ubontu?
i.e. in data directory.
Regards
Tarkeshwar
From: Asif Naeem [mailto:anaeem...@gmail.com]
Sent: 04 August 2014 16:01
To: M Tarkeshwar Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where the
Hi all,
I want to know the exact path of the core files generated by Postgres server
during crash?
Can I configure it or generate it?
Regards
Tarkeshwar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
From: M Tarkeshwar Rao
Sent: Wednesday, 09 July 2014 1:41 PM
To: Niklas Andersson; Leo Zhou; postgres-disc...@mailman.lmera.ericsson.se
Subject: RE: [postgres-discuss] Insert query hangs
CREATE TABLE eventlogentry
(
tableindex integer,
object character varying(80),
method
there any issue in indexing?
Is there any option to repair the table or its indexing?
Regards
Tarkeshwar
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of M Tarkeshwar Rao
Sent: 09 July 2014 14:49
To: pgsql-hackers-ow
Hi all,
We have a table in a database DB1 with name Test. We imported this database
from another machine.
When I fire insert statement it is going in the hang state.
Then I created another table with same structure and with same data within it
as in table Test.
Then I fired the insert statemen
Hi,
Insert query hangs what could be the reason. Is there any way to find out?
Any timeout feature there with query which can be set at client or server end?
Regards
Tarkeshwar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
Hi All,
I am facing one problem. I want to read the log files of postgres.
Actually our customer facing some problem in database. Continuously one error
exception raised by the system.
Error is:
2014-01-09 22:08:12.003, SEVERE, manager.Data Manager - Could not execute JDBC
batch update; SQL [
Hello Friends,
How to know cpu and memory utilization in postgres.
We require this information to show it on our Application using any postgres
command or tool.
Regards
Tarkeshwar
Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some
tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to
Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some
tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to
Hi all,
We are upgrading our mediation product from postgres 8.1 to postgres 9.1
Can you please suggest some test cases or some issues which may hamper us?
Regards
Tarkeshwar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
Hi all,
I am new in this group and need some help from your side.
We have a mediation product which is initially using Oracle as database.
Some of our customer interested to move Postgres 9.1.
Our mediation product storing some configuration related information in data
base and some type of lo
Hi all,
I am new in this group and need some help from your side.
We have a mediation product which is initially using Oracle as database.
Some of our customer interested to move Postgres 9.1.
Our mediation product storing some configuration related information in data
base and some type of lo
33 matches
Mail list logo
