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
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: rel
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
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
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
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
[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
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 info
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 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 f
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
> s
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:
> http://i
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
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
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 dur
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
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 symbol:
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
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 v
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
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]
---
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/
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 upda
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
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 downloa
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.
--
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
th
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?
1-27 at 11: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,
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? 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)---
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
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 probl
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
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 inse
51 matches
Mail list logo
