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
Hello All,
I am migrating oracle queries to postgres queries
*Oracle query is below*
select * from (select * from KM_COURSE_MAST where ID in (select OBJ_ID from
(select OBJ_ID,PERFORMER_TYPE,PERFORMER_ID from KM_REL_OBJ_PER_ACTION
where OBJ_TYPE='COURSETYPE') where PERFORMER_TYPE='GROUP'
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
I tried to create function to truncate table
1) when the user call the function just specify the tablename
2) the user can use the function owner privilege to execute the function.
But I got the errors as follows. Please help me to take a look.
Thanks.
Regards.
Grace
-- function :
CREA
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
Among following queries, only THREE runs fast enough for me.
I can't understand the logic behind this.
I once thought that shared buffers replacement is independent from
whether the backend which used it is still alive. But is it true?
Seems like shared buffers are "returned to the pool" or "fr
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
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.26, 2.43
My questions are,
1. Which postg
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
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 create the
account I get the message ' user account postgr
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
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 command was: SELECT tableoid, oid, adnum,
pg_cat
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
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 would look something like
SELECT state1, FIRST(timest
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
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.
Thanks in advance.
Machine details
---
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
dear sir
could you please help ?
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 [postgr
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
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
_
Your E-mail and More On-the-Go
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
Dear sir,
I work as a new DBA in postgresql, please recommend some good books, website
for tutorial.
thanks
Shu
_
Hotmail: Powerful Free email with security by Microsoft.
http://clk.atdmt
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
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 NTDLR is missing. What I did was I
re-installed my OS. When I finished my i
I am trying to get the following program to compile the following program
with Embedded SQL Processor:
#include
main()
{
printf( "I am alive\n" );
#if 0
EXEC SQL CONNECT TO DEFAULT;
#endif
printf( "status is %d\n", sqlca.sqlcode );
}
I am doing this as
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
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 P4 3.0, 512MB Memory, 40GB HDD. Server run
Windows Server 2003 o
Thanks for your repaly
I have done with that but facing the same problem.
Actually what i want to do is to add a table to a
already existing replication set.
firstly, I will have to create new set
secondly subscrib it .
and finaly merge it.
do i need to create this set in the same cluster into
Hi,
On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar wrote:
> create set (id=2, origin=1, comment='All tables');
>
> but it gives error
>
> syntax error near unexpected token `('
That command must be passed to slonik, not to bash.
Here is an example:
#!/bin/bash
slonik << _END_
cluster
I want to create new set,
I am running create set command as follows
create set (id=2, origin=1, comment='All tables');
but it gives error
syntax error near unexpected token `('
can anybody tell me where i am doing wrong
With regards
Ashish
_
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":
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":
/usr/lib/pgsql/xxid.so: f
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
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 PostgreSQL to use for
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
Oh my god!
DB is pg 7.4.6 on linux
2005-10-27 05:55:55 WARNING: some databases have not been vacuumed in
2129225822 transactions
HINT: Better vacuum them within 18257825 transactions, or you may have
a wraparound failure.
2005-10-28 05:56:58 WARNING: some databases have not been vacu
Hi anybody,
i a running PostgreSQL on Win2k and use PostgreSQL in my application via
an ODBC bridge.
In my aplication i create a database with default (SQL-ASCII) encoding,
strings containing vovels can be saved, but not read correctly.
I have created a database with WIN1250, WIN and UNIC
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
Hello sir
actually i am working with Qt using postgresql i have to get connection
{(database("trainee"),user("trainee"))}
from the network (database remote accessing) so i have configured
postgresql.conf and pg_hba.conf upto some extents
the fields that i have configured r as follows even t
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
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 PRIMARY KEY (dokumnr) );
CREATE TABLE rid ( dokumnr
1 - 100 of 119 matches
Mail list logo
