On 01/04/2016 06:07 PM, John Hong wrote:
Hello Everyone,
On 2015/12/30 17:51:01, Transaction was failed on our system.
I checked the pg_log, it states as below:
2015-12-30 17:51:01 CST [11260]: [42-1] LOG: 0: server process (PID
14272) was terminated by signal 11: Segmentation fault
On Tue, Jan 5, 2016 at 12:36 PM, John R Pierce wrote:
> On 1/4/2016 6:07 PM, John Hong wrote:
>
> EnterpriseDB 9.4.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
> 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit
>
>
>
> you probably should contact EnterpriseDB technical support. This email
> l
On 1/4/2016 6:07 PM, John Hong wrote:
EnterpriseDB 9.4.1.3 on x86_64-unknown-linux-gnu, compiled by gcc
(GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit
you probably should contact EnterpriseDB technical support. This email
list is for the community open source version of PostgreSQL.
--
On Mon, Aug 26, 2013 at 3:17 AM, gajendra s v wrote:
> Please explain me why it is ?
>
A good place to start would be removing all the parts here that don't seem
to matter. Your problem seems to be with the recursive query (since that is
the part you're changing). Cut off everything else and com
gresql.org
Cc: thodi.vi...@hotmail.com
Subject: Re: [GENERAL] Please help
Sent: Aug 13, 2013 10:00 PM
On 08/13/2013 10:29 AM, Thodi Viola wrote:
> The error mentioned is template1: FATAL: password authentication failed for user "postgres">
> orcan you see the attachment.
Well ei
On 08/14/2013 05:50 AM, coutinhovi...@gmail.com wrote:
Thank you Sr.,
I'll try to see who can help me. I can't access postgres server and create data
base without stack builder application installed.
You might want to try the EnterpriseDB forums:
http://forums.enterprisedb.com/forums/list.p
On 08/13/2013 10:29 AM, Thodi Viola wrote:
The error mentioned is
orcan you see the attachment.
Well either no password or the wrong password supplied for the postgres
user. I do not use StackBuilder, so someone else will need to help out
with the proper place/method to supply the password.
The error mentioned is orcan you see
the attachment.
Thodi Viola
2013/8/13 Adrian Klaver
> On 08/13/2013 08:57 AM, Thodi Viola wrote:
>
>> Dear Srs
>>
>> Could you please help me to fix the error shown in attachment, i'm use
>> windows 7.
>>
>>
>>
> What is in the error log mentioned in the
On 08/13/2013 08:57 AM, Thodi Viola wrote:
Dear Srs
Could you please help me to fix the error shown in attachment, i'm use
windows 7.
What is in the error log mentioned in the pop up?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
2012/4/3 Alban Hertroys
> On 2 Apr 2012, at 22:28, Bartosz Dmytrak wrote:
>
> > That is right, there is no sense to use cursors here...
>
> I think you're wrong there: The OP is querying a system table for tables
> of a certain name, which I expect can contain multiple rows for tables of
> the sa
On 2 Apr 2012, at 22:02, leaf_yxj wrote:
> CREATE OR REPLACE FUNCTION truncate_t(tablename IN VARCHAR) RETURNS void AS
> $$
> DECLARE
> stmt RECORD;
> statements CURSOR FOR SELECT tablename FROM pg_catalog.pg_tables;
> BEGIN
> IF stmt IN statements then
> EXECUTE 'TRUNCAT
On 2 Apr 2012, at 22:28, Bartosz Dmytrak wrote:
> That is right, there is no sense to use cursors here...
I think you're wrong there: The OP is querying a system table for tables of a
certain name, which I expect can contain multiple rows for tables of the same
name in different schema's.
Of c
That is right, there is no sense to use cursors here...
CREATE OR REPLACE FUNCTION truncate_t (IN tablename text)
RETURNS VOID
AS
$$
BEGIN
EXECUTE 'TRUNCATE TABLE ' || quote_ident(tablename) || 'CASCADE;';
EXCEPTION
WHEN undefined_table THEN
RAISE EXCEPTION 'Table "%" does not exists', tablename
Hello
" IF stmt IN statements then " is nonsense.
use trapping exceptions instead
BEGIN
EXECUTE 'TRUNCATE TABLE ' || quote_ident(_tablename) || ' CASCADE';
EXCEPTION WHEN undefined_table THEN
RAISE EXCEPTION 'your own exception, when you like';
END;
Regards
Pavel
2012/4/2 leaf_yxj :
> I
2012/1/6 Tom Lane :
> =?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes:
>> Among following queries, only THREE runs fast enough for me.
>> I can't understand the logic behind this.
>
> I'm not sure why you'd expect real answers when you haven't shown us
> what the query is doing,
it is an UDF, encapsu
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes:
> Among following queries, only THREE runs fast enough for me.
> I can't understand the logic behind this.
I'm not sure why you'd expect real answers when you haven't shown us
what the query is doing, but my first thought is that the discrepancy
comes
On 02/26/11 7:04 AM, savio rodriges wrote:
Hello Team,
I am new to Postgresql. Postgresql suddenly stoped responding. Below is what I
checked.
[root@server]$/etc/init.d/postgres status
dead but pid file exists
that probably means the server aborted for some reason without cleaning
up. thi
On 26/02/2011 16:00, savio rodriges wrote:
Please let me know how to configure "ERROR REPORTING AND LOGGING"
section of postgres.conf to get all necessary postgres information in
logfile for debuging/administration purpose.
I think you need to look at log_min_messages and log_error_verbosity
on of
postgres.conf to get all necessary postgres information in logfile for
debuging/administration purpose.
Thanks for your help.
Savio
--- On Sat, 2/26/11, Raymond O'Donnell wrote:
> From: Raymond O'Donnell
> Subject: Re: [GENERAL] Please help -- Postgres stopped respondi
On 26/02/2011 15:04, savio rodriges wrote:
Hello Team,
I am new to Postgresql. Postgresql suddenly stoped responding. Below
is what I checked.
[root@server]$/etc/init.d/postgres status dead but pid file exists
[root@server]$ uptime 20:33:26 up 63 days, 22:57, 4 users, load
average: 1.73, 2.2
On 04/11/10 16:58, Gavin Burrows wrote:
> I have literally been researching this for weeks! Now I feel I have
> reached a point where this has become an impossible task so I need help
> from the experts please :]
It sounds like you have Group Policy restrictions on password strength
in place.
Yo
Hi Gavin,
On 2010/11/04, at 17:58, Gavin Burrows wrote:
> I'm sure you have had this question many times before but I feel as though I
> have genuinely exhausted all of my option and followed all the advise I can
> find online.
>
> During installation of Postgresql at the time when it tries t
On Thu, Nov 4, 2010 at 1:58 AM, Gavin Burrows wrote:
> Hi
>
> I'm sure you have had this question many times before but I feel as though I
> have genuinely exhausted all of my option and followed all the advise I can
> find online.
>
> During installation of Postgresql at the time when it tries to
Now if you told people the OS, and the version of Postgres maybe ... ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In response to peeratat tungsungnern :
>
> My HDD has bad sector and i can change new HDD. I have a ploblem can't back
> up database and display massage is:
>
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: cache lookup failed for function
> 137832813
> pg_dump: The
Nikolas Everett wrote:
> Sorry. Here is the setup:
> CREATE TABLE test (id BIGSERIAL PRIMARY KEY, state1 INT NOT NULL, state2 INT
> NOT NULL, timestamp TIMESTAMP);
> INSERT INTO test (state1, state2, timestamp) VALUES (1, 1, now() - interval
> '12 hours');
> INSERT INTO test (state1, state2, tim
Got it:
SELECT state1, timestamp
FROM (SELECT state1, timestamp, lag(state1) OVER (ORDER BY timestamp)
FROM test) as foo
WHERE state1 != lag OR lag IS NULL
ORDER BY timestamp;
state1 | timestamp
+
1 | now() - interval '12 hours'
The 10 and 11 hour interval are being skipped because I'm only interested in
the transitions of state 1. State 1 only transitioned three times at now -
12, now - 9 and now - 8.
The table has both transitions in it because I frequently care about them
both together. I just don't in this case.
On
On 5/27/2010 9:45 AM, Nikolas Everett wrote:
> Sorry. Here is the setup:
> CREATE TABLE test (id BIGSERIAL PRIMARY KEY, state1 INT NOT NULL,
> state2 INT NOT NULL, timestamp TIMESTAMP);
> INSERT INTO test (state1, state2, timestamp) VALUES (1, 1, now() -
> interval '12 hours');
> INSERT INTO tes
On 5/27/2010 9:04 AM, Nikolas Everett wrote:
> Say I have a table that stores state transitions over time like so:
> id, transitionable_id, state1, state2, timestamp
>
> I'm trying to write a query that coalesces changes in state2 away to
> produce just a list of transitions of state1. I guess it
Sorry. Here is the setup:
CREATE TABLE test (id BIGSERIAL PRIMARY KEY, state1 INT NOT NULL, state2 INT
NOT NULL, timestamp TIMESTAMP);
INSERT INTO test (state1, state2, timestamp) VALUES (1, 1, now() - interval
'12 hours');
INSERT INTO test (state1, state2, timestamp) VALUES (1, 2, now() - interva
Lost me a bit, do you mean DISTINCT?
select distinct state1, first(timestamp) from table
On May 27, 2010, at 10:04 AM, Nikolas Everett wrote:
> Say I have a table that stores state transitions over time like so:
> id, transitionable_id, state1, state2, timestamp
>
> I'm trying to write a qu
Tom Lane wrote:
pgsql writes:
Tom Lane wrote:
Um, that's not too helpful, we want to see the string it's pointing at.
Sorry about that. All statements are calling one of two pl/pgsql
functions. While that information already helps me a lot, it'll take me
a while to step through the code. T
pgsql writes:
> Tom Lane wrote:
>> Um, that's not too helpful, we want to see the string it's pointing at.
> Sorry about that. All statements are calling one of two pl/pgsql
> functions. While that information already helps me a lot, it'll take me
> a while to step through the code. Those funct
Tom Lane wrote:
pgsql writes:
Tom Lane wrote:
Looking at debug_query_string in the core dumps would
at least show what SQL command is calling the function(s) --- and I
wouldn't be surprised if there's exactly one function involved here.
Content of debug_query_string:
core.21207
$1 = 6310
pgsql writes:
> Tom Lane wrote:
>> Looking at debug_query_string in the core dumps would
>> at least show what SQL command is calling the function(s) --- and I
>> wouldn't be surprised if there's exactly one function involved here.
> Content of debug_query_string:
> core.21207
> $1 = 63106368
U
Tom Lane wrote:
pgsql writes:
Looking at debug_query_string in the core dumps would
at least show what SQL command is calling the function(s) --- and I
wouldn't be surprised if there's exactly one function involved here.
Content of debug_query_string:
core.21207
$1 = 63106368
core.20832
$1 =
Alvaro Herrera wrote:
pgsql wrote:
Hi,
one of our pgsql instances recently started to segfault multiple times a
week. I tried a couple of things to pin it down to a certain query
or job but failed to find any pattern. All I can offer is some notes
and a set of similar looking back traces.
Ple
On 5/05/2010 5:27 AM, Alvaro Herrera wrote:
pgsql wrote:
Hi,
one of our pgsql instances recently started to segfault multiple times a
week. I tried a couple of things to pin it down to a certain query
or job but failed to find any pattern. All I can offer is some notes
and a set of similar look
pgsql writes:
> one of our pgsql instances recently started to segfault multiple times a
> week. I tried a couple of things to pin it down to a certain query
> or job but failed to find any pattern. All I can offer is some notes
> and a set of similar looking back traces.
BTW, there is a post-8.3
pgsql writes:
> one of our pgsql instances recently started to segfault multiple times a
> week. I tried a couple of things to pin it down to a certain query
> or job but failed to find any pattern. All I can offer is some notes
> and a set of similar looking back traces.
All of those traces seem
pgsql wrote:
> Hi,
>
> one of our pgsql instances recently started to segfault multiple times a
> week. I tried a couple of things to pin it down to a certain query
> or job but failed to find any pattern. All I can offer is some notes
> and a set of similar looking back traces.
Please install th
In response to Shu Ho :
>
> I have postgres installed in mac and want to connect it from window XP, I get
> error, can you please help what is needed to get connected to mac server
> postgres ?
>
> Server [localhost]: 10.1.1.9
> Database [postgres]: viewods
> Port [5432]: 5433
> Username [postg
Shu Ho wrote:
Dear sir,
I need to install postgresql in unix solaris, can you please help with
the config file set up and more detail set up instructions.
Solaris 10 comes with several versions of PostgreSQL. if you have a
reasonably recent release of sol10, you should have 8.3.x, and you ne
On Saturday 02 January 2010 11:35:42 am Shu Ho wrote:
> Dear sir,
>
> I need to install postgresql in unix solaris, can you please help with the
> config file set up and more detail set up instructions.
>
>
>
> thanks
>
> Sue
>
> _
> Y
On 02/01/2010 19:35, Shu Ho wrote:
> Dear sir,
> I need to install postgresql in unix solaris, can you please help with
> the config file set up and more detail set up instructions.
The first place to start is with the documentation - there are very
detailed instructions on installation and the co
Funny thing, a workmate ask me about this same type of question. I found this
book to be useful.
http://www.amazon.com/Beginning-Databases-PostgreSQL-Novice-Professional/dp/1590594789/ref=sr_1_2?ie=UTF8&s=books&qid=1262365492&sr=8-2
I will second Craig's recommendation, though, since good Postg
Shu Ho wrote:
> Dear sir,
> I work as a new DBA in postgresql, please recommend some good books,
> website for tutorial.
The best starting point is the PostgreSQL documentation:
http://postgresql.org/docs
Additionally, remain subscribed to this mailing list, and read the
discussions that happe
On Thu, 2009-07-16 at 04:47 -0700, Roseller A. Romanos wrote:
> Please help me with this. I really need your advice as to how to
> retrieve the data in my postgresql database.
>
> I have postgresql installed in Windows XP platform five months ago.
> Just yesterday my OS bugged down and saying NTDL
Hello, Roseller !
>
> What should I do to access my database and retrieve the important records in
> it?
Possible you should keep files in database cluster, recreate db
cluster and put your old files into newly created cluster.
--
Best regards,
Sincerely yours,
Yuriy Rusinov.
--
Sent via pgsq
Hi,
I will have to try again. I know that I was probably not specific enough in
my first attempt.
The systems on which we have tested and are getting the error:
- PostgreSQL 8.2.4 (also tried 8.2.6 without db upgrade) configured with
'enable_thread_safety'.
- Linux Slackware 10.2.0
In response to hengky liwandouw <[EMAIL PROTECTED]>:
> Dear all,
>
> I have another problem with Access 2003 as front end with Postgre 8.1, ODBC
> version 8.02.02 Unicode.
>
> I just upgrade the Point of Sales Program to Access 2003 MDE, all station
> running XP Home wth Access 2003
On Thu, Mar 01, 2007 at 02:31:12AM -0800, hengky liwandouw wrote:
> Dear all,
>
> I have another problem with Access 2003 as front end with Postgre 8.1, ODBC
> version 8.02.02 Unicode.
>
> I just upgrade the Point of Sales Program to Access 2003 MDE, all station
> running XP Home wth
I am using Redhat Linux 4
Now the problem is solved.I installed Postgres 8.1.5
from source code previously it was installed using rpm
on slave machine.
but then i am having one problem :
I am left with following details
I am having two machine
1)Master machine :
Redhat linux
PostgreSQL 8.1.5 -- i
Ashish Karalkar wrote:
Thanks Chris ,
I ahve checked the permissions on the xxid.so file and
it ids having all permission i.e. 0777
I think its not getting the permission from the object
which xxid.so is refering, any idea which object it is
refering
Are you running SeLinux by any chance? T
Thanks Chris ,
I ahve checked the permissions on the xxid.so file and
it ids having all permission i.e. 0777
I think its not getting the permission from the object
which xxid.so is refering, any idea which object it is
refering
With Regards
Ashish Karalkar
--- Chris <[EMAIL PROTECTED]> wrote:
Ashish Karalkar wrote:
I am having PostgreSQL 8.1.5 binary loaded on linux
machine.
I am using Slony 1.2.1 for replication database.Bothe
master and slave will be on localhost, while
configuring the database I am getting following error
massage.
could not load library "/usr/lib/pgsql/xxid.so":
Hi,
On Wed, 2006-01-25 at 12:40 +0300, Sergey Karin wrote:
> We create database cluster (via initdb) on some disk. Then we create
> and use a database that can be very large. In some moment the database
> occupy all disk space allicated to cluster.
> The question is: are there any abilities in Po
Sergey Karin wrote:
Hi, List!
Lets suppose the next situation...
We create database cluster (via initdb) on some disk. Then we create and use
a database that can be very large. In some moment the database occupy all
disk space allicated to cluster.
The question is: are there any abilities in Po
On Wed, Jan 25, 2006 at 12:40:36PM +0300, Sergey Karin wrote:
> Hi, List!
>
> Lets suppose the next situation...
>
> We create database cluster (via initdb) on some disk. Then we create and use
> a database that can be very large. In some moment the database occupy all
> disk space allicated to c
On Mon, Oct 31, 2005 at 05:27:15PM -, John Sidney-Woollett wrote:
> > Wonder if it would be a good idea for the error messages to identify which
> > databases might have lost data.
> >
> > However if you have a fair number of databases involved you might get a
> > fair number of log messages. S
Lincoln Yeoh said:
> At 07:48 PM 10/30/2005 +, John Sidney-Woollett wrote:
>
>>"Panic" - that's my middle name. ;)
>>
>>Had I known how to identify the database at fault, and that it would have
>>had no effect on the other databases, then I would have handled this
>>episode differently.
>
> Won
At 07:48 PM 10/30/2005 +, John Sidney-Woollett wrote:
"Panic" - that's my middle name. ;)
Had I known how to identify the database at fault, and that it would have
had no effect on the other databases, then I would have handled this
episode differently.
Wonder if it would be a good idea
"Panic" - that's my middle name. ;)
Had I known how to identify the database at fault, and that it would
have had no effect on the other databases, then I would have handled
this episode differently.
In the event, things seem to be OK. Our old slave db is now acting as
master and the old mas
Martijn
Thanks for the answers/thoughts...
Vacuumuming the databases hammers the server so the vacuums are spread
out at different times during the night/morning. Plus template1 is
vacuumed once a week.
I guess I was unlucky to have missed the vacuum on that unused database
(due to my misun
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> Just out of curiousity would the wraparound error (for mail_lxtreme)
> actually have affected data in bp_live?
> Could I just have deleted mail_lxtreme and then continued to use bp_live
> as though nothing had happened?
No, and yes, which is why
On Sun, Oct 30, 2005 at 06:41:45PM +, John Sidney-Woollett wrote:
> Hmm. I'm pretty sure that database mail_lxtreme was unused (no
> connections/activity) - I didn't think that it would need to be vacuumed
> at all...
A database that is never used still needs to be vacuumed. The only
excepti
Hmm. I'm pretty sure that database mail_lxtreme was unused (no
connections/activity) - I didn't think that it would need to be vacuumed
at all...
Just out of curiousity would the wraparound error (for mail_lxtreme)
actually have affected data in bp_live?
Could I just have deleted mail_lxtrem
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> OK, I restored the pgsql/data to another server and started up postgres
> and this is what I got:
> SELECT datname, age(datfrozenxid) FROM pg_database;
> datname| age
> --+-
> mail_lxtreme | -2074187459
>
OK, I restored the pgsql/data to another server and started up postgres
and this is what I got:
SELECT datname, age(datfrozenxid) FROM pg_database;
datname| age
--+-
mail_lxtreme | -2074187459
bp_live | 1079895636
template1| 1076578064
template0
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> I can restore the file system backup of pgsql/data to another database
> server and then get the info from pg_database. Or I can import a dump
> file from 15 minutes before I re-inited the database...
Importing a dump will tell you nothing at al
Hi Tom
You're not wrong about panicking! This is the worst Sunday I've had in a
while... No sunday lunch or time with the kids... :(
This database supports a (normally 24/7) website and we couldn't
tolerate any possibility of data corruption. I had to make a judgement
call on preventing any/
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> I decided to switch over to the slave which is now our live database.
> the old master with the problem has already been re-inited (although I
> have a cold backup of the data dir), plus dump files that I can restore
> from.
You panicked much t
Martin, thanks for the feedback.
I had a look around and couldn't see any data loss (but wasn't really
sure where to start looking).
I decided to switch over to the slave which is now our live database.
the old master with the problem has already been re-inited (although I
have a cold backup
On Sun, Oct 30, 2005 at 08:50:18AM +, John Sidney-Woollett wrote:
> Oh my god!
>
> DB is pg 7.4.6 on linux
Firstly, check pg_database, it should tell you which databases need to
be vacuumed. Any database you regularly vacuumed is fine so maybe the
corruption is in some other database you
On Apr 21, 2005, at 1:22 AM, amit kumar awasthi wrote:
# Using sockets credentials for improved security. Not available
everywhere,
# but works on Linux, *BSD (and probably some others)
local all all ident sameuser
#local all all 127.0.0.1 sameuser
only this en
On Apr 12, 2005 9:40 AM, Andrus <[EMAIL PROTECTED]> wrote:
The following statement runs VERY slowly on large tables.Any idea how to speed it up ?UPDATE rid SET dokumnr=NULL WHERE dokumnr NOT IN (SELECT dokumnr FROM dok);Tables:CREATE TABLE dok ( dokumnr INTEGER, CONSTRAINT dok_pkey PRIM
CY wrote:
I wanted a auto-increasement function, similar to sequence, to increase
a field. I cannot use CREATE SEQUENCE because it cd_line_no will start
again with a new coursedetail.
CREATE TABLE coursedetail
(
cd_cf_id char(30),
cd_line_no smallint default auto_increment b
Hi,
First of call can you make sure you are using the latest source. There
are binaries at http://jdbc.fastcrypt.com
Second, my instincts are telling me that there is some sort of overflow
occurring with 6k records. Is there some way to reduce the size of the
resultset?
Dave
-Original Mess
From: "Vijayan" <[EMAIL PROTECTED]>
> I have a registration database. I need to know number of
> registrations / month in a report format. How will I get a report like
> this ?
>
> In Oracle I can give the query like this:-
> "select to_char(reg_date, 'Mon '), cou
"Alok K. Dhir" <[EMAIL PROTECTED]> writes:
> ERROR: readDatum: ']' expected, length = 12
Hm, are you sure that was 7.1b3, and not something even older? Looking
at the CVS logs, the last change in stored rule format was between beta1
and beta2, so I'd expect this sort of failure if you tried t
I had asked something simular a week back.
This should help you :-)
http://fts.postgresql.org/db/mw/msg.html?mid=121203
cheers,
thalis
ps did someone play too much with the majordomo? it screwes up the list addresses in
Cc: when I reply to a message
On 12 Jun 2001, Alla wrote:
> Guys;
>
>
Bo Berkhaut writes:
> CREATE TABLE example (name text, slots text[]);
>
> I want to be able to select, for example, all rows such that an element
> of example.slots exists equal to example.name.
There are some operators for this in contrib/array.
However, I'd say that if you're trying to do thi
> > Please help me recover our database from what I think
> > is a duplicate key in unique index problem.
>
> This may not help, and forgive my asking the obvious, but have
> you done a SELECT on the table and actually *seen* duplicate 'id'
> values in the SERIAL column? That would surprise me be
, 1998 5:55 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Please help with performance tuning on Postgres
I assume you have read the FAQ item on performance. It is on the web
site.
> I have a database running fine, however, it is purely stock configuration.
I
> would like to fine tune
85 matches
Mail list logo
