On 10/8/13 5:55 AM, shailesh singh wrote:
HINT: To avoid a database shutdown, execute a full-database VACUUM in
debug.
ERROR: could not access status of transaction 449971277
DETAIL: could not open file pg_clog/01AD: No such file or directory
Unless I'm mistaken, that missing CLOG file is
I had got this message while running vacuum full from backend . Now My
database is not starting , Help pls.
backend vacuum full debug;
WARNING: database debug must be vacuumed within 99 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
debug.
ERROR:
*Don't* VACUUM FULL. Just VACUUM. It's not the same thing.
...Robert
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 19/04/12 06:23, Josh Berkus wrote:
Nagaraj,
i am nagaraj, i am newbi in this database world. i required your help.
2 dyas back i formatted one of my client system. which is having postgresql
8.2 database that was having data. but i am not taken backup of the data.
1) how to take the data
Hi team,
i am nagaraj, i am newbi in this database world. i required your help.
2 dyas back i formatted one of my client system. which is having postgresql
8.2 database that was having data. but i am not taken backup of the data.
1) how to take the data from the formatted harddisk. ?
2) how many
Nagaraj,
i am nagaraj, i am newbi in this database world. i required your help.
2 dyas back i formatted one of my client system. which is having postgresql
8.2 database that was having data. but i am not taken backup of the data.
1) how to take the data from the formatted harddisk. ?
2) how
I need to be Unsubscribed! ign...@verizon.net
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sun, May 15, 2011 at 4:57 PM, Gelman ign...@verizon.net wrote:
I need to be Unsubscribed! ign...@verizon.net
There's a link for that here:
http://archives.postgresql.org/pgsql-hackers/
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via
[Camilo Porto]
Date: Tue, 30 Oct 2007 16:09:01 +
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
CC: pgsql-hackers@postgresql.org
2007/10/30, Camilo Porto [EMAIL PROTECTED]:
I am simulating only 1 client
[Camilo Porto]
Date: Sat, 27 Oct 2007 18:12:28 +0100
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
CC: pgsql-hackers@postgresql.org
2007/10/27, Camilo Porto [EMAIL PROTECTED]:
The parallelism happens even if my PC has only
2007/10/30, Camilo Porto [EMAIL PROTECTED]:
I am simulating only 1 client with the Benchmark. Can 1 Client submit
parallel queries, in single-processor enviroment?
If this client uses two connections, you can run two queries in paralell.
The client uses only 1 connection. In this
Camilo Porto wrote:
In some tests I have done, I have found these results:
- Total Time interval which BenchmarkSQL submitted queries = 30 seconds
- sum of executor's duration time during this period of time = 2
minutes and 36 seconds!! (5x longer than total time)
Are you sure you're not
[Camilo Porto]
To: [EMAIL PROTECTED]
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
Date: Fri, 26 Oct 2007 23:06:22 -0400
From: [EMAIL PROTECTED]
Camilo Porto [EMAIL PROTECTED] writes:
The problem I have encountered is that the sum
2007/10/27, Camilo Porto [EMAIL PROTECTED]:
The parallelism happens even if my PC has only one processor?
PostgreSQL creates a separate process for each client connection -
whether you have one CPU or more.
Each query is executed in a separeted Thread?
No threads, at least on Unix. Regular
Hi,
I
have been doing my master degree research and I am using Postgresql
8.2.5. I would appreciate if anyone could help me, ASAP, concerning the
following question:
How can I obtain the time spent by the Postgresql EXECUTOR during a given
time interval?
I am trying to get the above
Camilo Porto [EMAIL PROTECTED] writes:
The problem I have encountered is that the sum of executor's
duration time is, *sometimes*, bigger than the total time interval in
which the statements had been executed!! And this makes no sense!
Umm ... why not? If you have, say, two queries executing
On 2/26/07, Merlin Moncure [EMAIL PROTECTED] wrote:
On 2/23/07, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
On friday we upgraded a critical backend server to postgresql 8.2
running on fedora core 4.
Umm ... why that particular choice of OS? Red Hat dropped
On Thu, Mar 01, 2007 at 08:32:57AM -0500, Merlin Moncure wrote:
Following an emergency downgrade back to 8.1, the kernel panics went
away. Note that I don't believe for a second that the database was
the root cause here...research suggest that the problem is due to some
type of bug in the
On Fri, Feb 23, 2007 at 18:14:25 -0500,
Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
On friday we upgraded a critical backend server to postgresql 8.2
running on fedora core 4.
Umm ... why that particular choice of OS? Red Hat dropped update
support for
On Mon, Feb 26, 2007 at 15:57:02 +0200,
Devrim GUNDUZ [EMAIL PROTECTED] wrote:
Upgrading OS will probably solve your problem; since there is no way to
upgrade FC4 kernel unless you want to compile kernel source on your
system.
And good luck with that. Fedora still back patches stuff from
On 2/23/07, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
On friday we upgraded a critical backend server to postgresql 8.2
running on fedora core 4.
Umm ... why that particular choice of OS? Red Hat dropped update
support for FC4 some time ago, and AFAIK the
Hi,
On Mon, 2007-02-26 at 08:24 -0500, Merlin Moncure wrote:
we tried update to the latest via yum update with no help.
As Tom stated, FC4 is no more supported; therefore you won't be able to
get newer kernel via yum.
as promised, here is the best photo of the panic we could get:
Ok,
This may the wrong place to look for answers to this, but I figured it
couldn't hurt...so here goes:
On friday we upgraded a critical backend server to postgresql 8.2
running on fedora core 4. Since then we have received three kernel
panics during periods of moderate to high load (twice
Merlin Moncure [EMAIL PROTECTED] writes:
On friday we upgraded a critical backend server to postgresql 8.2
running on fedora core 4.
Umm ... why that particular choice of OS? Red Hat dropped update
support for FC4 some time ago, and AFAIK the Fedora Legacy project
is not getting things done.
On 2/23/07, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
On friday we upgraded a critical backend server to postgresql 8.2
running on fedora core 4.
Umm ... why that particular choice of OS? Red Hat dropped update
support for FC4 some time ago, and AFAIK the
On Mon, 18 Apr 2005, ElayaRaja S wrote:
My postgresql was running successfully in my Redhat LInux 9. After
1 day when i try to login to the folder /usr/local/pgsql/data to
update the ip address i am getting
as
[EMAIL PROTECTED] data]# ls
Segmentation fault
I am unable to see the files under
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
--
Warm Regards,
S.ElayaRaja
Mobile: (+91) 98450 59540
E-Mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]
Le Monday 18 April 2005 13:47, ElayaRaja S a écrit :
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
rpm -e postgresql ?
I am not sure this kind of question should
ElayaRaja S said:
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and i
have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
error: package postgresql is not installed
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
error: package postgresql is not installed
if i try to check the
HI,
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
if i install the postgreSQL 7.4.5 and i used the command,
bash-2.05b$ psql
psql: relocation error: psql: undefined
On 4/18/05, ElayaRaja S [EMAIL PROTECTED] wrote:
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
Hello,
You really should consider asking your question on some another
Clinging to sanity, [EMAIL PROTECTED] (ElayaRaja S) mumbled into her beard:
Hi,
I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2
I am getting as [EMAIL PROTECTED] root]# rpm
Hi,
My postgresql was running successfully in my Redhat LInux 9. After
1 day when i try to login to the folder /usr/local/pgsql/data to
update the ip address i am getting
as
[EMAIL PROTECTED] data]# ls
Segmentation fault
I am unable to see the files under /usr/local/pgsql/data/,
I need to
When I try to input a unicode caracter which code is greater than
U+2, phpPgAdmin returns the following error message :
ERROR: Unicode characters greater than or equal to 0x1 are not
supported
Could someone fix this problem ?
If yes, would you please tell me where can i download the
Hi all,
When I try to input a unicode caracter which code is greater than
U+2, phpPgAdmin returns the following error message :
ERROR: Unicode characters greater than or equal to 0x1 are not
supported
Could someone fix this problem ?
If yes, would you please tell me where can i
First, read the developer's FAQ. Second, you probably will want to look
at /contrib and see if it can be made into a loadable module. I am not
sure we would want to have the datacube stuff in the main backend source
tree.
First, read the developer's FAQ. Second, you probably will want to look
at /contrib and see if it can be made into a loadable module. I am not
sure we would want to have the datacube stuff in the main backend source
tree.
Why not? It's in SQL99...
Chris
---(end
Yes, I was wrong. I now see it can't be a loadable module. I actually
thought it was for data warehousing and not standard SQL.
---
Christopher Kings-Lynne wrote:
First, read the developer's FAQ. Second, you probably
Hi!
We have written two new files by name datacube.c in tcop directory
and datacube.h in include directory. We have even changed some
exsisting files. We have made a patch of the files that have been
changed.
But how should we send the new files datacube.c, and datacube.h along with
On 29 Jun 2003 at 19:25, Srikanth M wrote:
Please tell the procedure of submitting a new file along with the patch.
subscribe to patches list and send the patch there along with descriptions of
changes you have made.
HTH
Bye
Shridhar
--
COBOL: An exercise in Artificial Inelegance.
Has anyone seen this behavior? It's corrupted a production database.
ERROR: heap_mark4update: (am)invalid tid
WARNING: Error occurred while executing PL/pgSQL function issuewomaterial
WARNING: line 40 at SQL statement
---(end of broadcast)---
ps - this is on 7.3.1. It never happened on 7.2.3...
- Original Message -
From: Ned Lilly [EMAIL PROTECTED]
To: PostgreSQL Hackers [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 11:04 AM
Subject: [HACKERS] urgent: db corruption - invalid TIDs?
Has anyone seen this behavior? It's
Ned Lilly wrote:
Has anyone seen this behavior? It's corrupted a production database.
Hi Ned,
Just as information filler, which version of PostgreSQL, and which
operating system?
:-)
Regards and best wishes,
Justin Clift
ERROR: heap_mark4update: (am)invalid tid
WARNING: Error occurred
:06, Ned Lilly wrote:
ps - this is on 7.3.1. It never happened on 7.2.3...
- Original Message -
From: Ned Lilly [EMAIL PROTECTED]
To: PostgreSQL Hackers [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 11:04 AM
Subject: [HACKERS] urgent: db corruption - invalid TIDs?
Has
, in
short, never mind.
Thanks,
NL
- Original Message -
From: Ned Lilly [EMAIL PROTECTED]
To: PostgreSQL Hackers [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 11:06 AM
Subject: Re: [HACKERS] urgent: db corruption - invalid TIDs?
ps - this is on 7.3.1. It never happened on 7.2.3
Hi
Were two doctoring students and we have a little problem to resolve.
Were using Grass5pre3 and PostgreSQL 7.2 (Linux)to map vehicular
pollution of our city. We have a map of the streets and we have to
assign 24 values (+ the label) to each street.
What would be a smart way to solve this
On Fri, 12 Jul 2002, [EMAIL PROTECTED] wrote:
Hi
Were two doctoring students and we have a little problem to resolve.
Were using Grass5pre3 and PostgreSQL 7.2 (Linux)to map vehicular
pollution of our city. We have a map of the streets and we have to
assign 24 values (+ the label) to each
Hi All,
This is my first post, so I hope I'm in the right
area and doing it correctly.
We are having MAJOR URGENT problems with
Postresql occaisonly corrupting tables on insert. I had a quick look
through your archive and couldn't find anything.It seems to happen mostly
on large inserts
Bruce Irvine [EMAIL PROTECTED] writes:
We are having MAJOR URGENT problems with Postresql occaisonly corrupting =
tables on insert.
Can't help you with that much information.
What Postgres version is this? (If your answer is not 7.0.3 or
7.1.2, I'm going to tell you to upgrade before
How 'bout posting what version of pgsql you're running, and we'll start
back at square one :)
-d
Bruce Irvine wrote:
Hi All,
This is my first post, so I hope I'm in the right area and doing it
correctly.
We are having MAJOR URGENT problems with Postresql occaisonly
51 matches
Mail list logo