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 f
*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 f
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
On Sun, May 15, 2011 at 4:57 PM, Gelman 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 pgsql-hackers mai
[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]>:
>
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
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. I
[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]>:
>
&
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
[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:
> >
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 execut
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 t
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? R
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
"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 do
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]
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 anot
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 instal
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
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 /usr/
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 ne
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 w
> 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
---(en
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.
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.
--
t. So, 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?
I don't know if this is terribly helpful, but the message was around in
7.2.x, look at src/backend/access/heap/heapam.c around line 1808 (or
1823 in the 7.3.x code)
That said, I've not seen it before, perhaps you can expand upon what
your function is doing?
Robert Treat
On Mon, 2003-01-27 at 11:
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 w
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?
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 e
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
"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 bef
33 matches
Mail list logo
