It looks like to be a data corruption case a few cases like this have
been discussed in the past as well. The following link -->
http://archives.postgresql.org/pgsql-general/2006-12/msg01546.php might help
you resolve the problem.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/31/07, Steve Holdoway <[EMAIL PROTECTED]> wrote:
The table I'm concerned with at the moment have (currently) 5 million
rows, with a churn of about 300,000 rows a week. The table has about a
million hits a day, which makes it the main potential bottleneck in this
database.
Why would it be
Availability of hardware monitoring software, and my personally being sick of
things falling over. I have to run Mysql 4.0 on this server at the moment, and
wasn't prepared to take the risk (:
Maybe by the time we implement, 64 bit will be reliable enough.
Steve
On Thu, 1 Feb 2007 09:25:08 +11
You might have more luck here: http://archives.postgresql.org/pgsql-admin/
GURON Rawender wrote:
Before printing, please consider the environment.
IMPORTANT NOTICE: This e-mail and any attachment to it are intended
only to be read or used by the named addressee. It is confidential and
may
IMPORTANT NOTICE: This e-mail and any attachment to it are intended only to be
read or used by the named addressee. It is confidential and may contain legally
privileged information. No confidentiality or privilege is waived or lost by
any mistaken transmission to you. The RTA is not responsi
I don't know about your table question, but may I ask why you're running
32-bit when you have dual Xeon processors?
I have dual Xeon's in my DWH, and I used to run 32-bit which I upgraded to
64-bit over Christmas. We run a nightly import to that database which used
to take around 5 hours which now
I'm got the enviable task of redesigning an MySQL based project from scratch.
We need a proper rdbms for this project, and I want to use PG 8.2.
The table I'm concerned with at the moment have (currently) 5 million rows,
with a churn of about 300,000 rows a week. The table has about a million hi
I am starting to have some significant problems with one of my
8.1.3databases. I am getting more and more of these errors:
wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,16,2007-01-31
15:31:48 EST,342126177,UPDATE,ERROR: could not access status of transaction
253762136
wbd,20552,dho
On 1/30/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Peter Koczan" <[EMAIL PROTECTED]> writes:
> So, is there any remedy to my problem (see below) short of granting
> superuser access? Is this a bug (which I would then report on the
> appropriate channels)?
It's not a bug.
> As for Tom's suggestio
Andrew Zahn <[EMAIL PROTECTED]> writes:
> Does anyone know what postmaster is doing with these UDP ports?
Statistics collection.
regards, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Does anyone know what postmaster is doing with these UDP ports?
On a fresh installation these ports are opened and I cannot find any
documentation on what they are for
postmaste 5398 postgres3u IPv4 53988 TCP *:5432 (LISTEN)
postmaste 5398 postgres5u IPv4 53994 UDP
I create this connected to postgres database:
create role prueba_role with nosuperuser nocreatedb nocreaterole nologin
noinherit;
revoke all on database prueba_roles from prueba_role cascade;
revoke create on database prueba_roles from prueba_role cascade;
create user sidar with password 'sidar'
"Alexandre Leclerc" <[EMAIL PROTECTED]> writes:
> We have a column (varchar) that has plain text time and it is indexed.
> When I do a query with the index, all the data is in the right order,
> but when I user ORDER BY .. DESC, the order is messed up. Example:
> By index 1: (date, time, data)
> S
Hi all,
I don't want to double post, but I see nothing hapening in the general
mailling list, so I post here in case any one has an idea about what
is going on.
We have a column (varchar) that has plain text time and it is indexed.
When I do a query with the index, all the data is in the right o
There were similar discussions for mozilla and linux. I don't know more
than what's in the articles. Perhaps there are people in the know on this
list. Hope this is not too irrelevant.
http://hecker.org/mozilla/eccn
http://www.linuxjournal.com/article/7311
http://www.bakernet.com/ecommerce/us
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I wonder if it isn't time to remove the split tarballs. Do they buy us
> anything?
Not much except confusion, AFAICS. Marc's still convinced they're
helpful though ...
regards, tom lane
---(end of broa
> -Original Message-
> How can I create a role and some reestrictions on it?
> The case is that I have many databases and thousands of
> users, I need to
> create users and these users can only connect to only one
> database and no
> more.
>
> Please help me.
>
Hello Sidar!
Perhaps
How can I create a role and some reestrictions on it?
The case is that I have many databases and thousands of users, I need to
create users and these users can only connect to only one database and no
more.
Please help me.
_
Char
Στις Τετάρτη 31 Ιανουάριος 2007 16:36, ο/η Bernd Nicklas έγραψε:
> Thanks! You're right. I didn't know that i need some more tarballs for
> complete installation :-)
>
You dont need no extra tarballs.
Just postgresql-8.2.1.tar.bz2
> Best regards,
> Bernd Nicklas
>
> Alvaro Herrera wrote:
> > Ber
Thanks! You're right. I didn't know that i need some more tarballs for
complete installation :-)
Best regards,
Bernd Nicklas
Alvaro Herrera wrote:
Bernd Nicklas wrote:
Hello,
i've got a problem with compiling postgresql-8.2.1.
My operating system distribution is ubuntu-6.10 with gnu make-
Bernd Nicklas wrote:
> Hello,
>
> i've got a problem with compiling postgresql-8.2.1.
> My operating system distribution is ubuntu-6.10 with gnu make-3.81-2 and
> gcc-4.1.1.
> The last few output lines of gmake are:
>
> make -C makefiles all
> make[2]: Entering directory
> `/home/sue/Desktop/Se
Hello,
i've got a problem with compiling postgresql-8.2.1.
My operating system distribution is ubuntu-6.10 with gnu make-3.81-2 and
gcc-4.1.1.
The last few output lines of gmake are:
make -C makefiles all
make[2]: Entering directory
`/home/sue/Desktop/Setups/postgresql-8.2.1/src/makefiles'
m
22 matches
Mail list logo
