And the version is 8.2.4
2010/11/22 Lukasz Brodziak :
> Hello,
>
> I got access to corrupted DB... The SELECT COUNT(*) FROM users where
> id_usr IS NULL returned error of invalid page header in one of the
> blocks...
>
> And the ANALYZE users got me an error that one of the pg_clog files is
> miss
Hello,
I got access to corrupted DB... The SELECT COUNT(*) FROM users where
id_usr IS NULL returned error of invalid page header in one of the
blocks...
And the ANALYZE users got me an error that one of the pg_clog files is
missing...
2010/11/21 Matthew Walden :
> Oh and could we please have the
Lou Picciano writes:
> Sure - of course - performance, too! It just seems like such an obvious
> candidate for a configurable option; I'm a bit surprised it isn't in there...
> L
It *is* configurable: make pg_xlog a symlink. The reason we don't
handle this via postgresql.conf is that you coul
Sure - of course - performance, too! It just seems like such an obvious
candidate for a configurable option; I'm a bit surprised it isn't in there... L
- Original Message -
From: "Joshua D. Drake"
To: "Lou Picciano"
Cc: "Tom Lane" , "pgsql-admin"
Sent: Sunday, November 21, 2010 10
On Mon, 2010-11-22 at 03:09 +, Lou Picciano wrote:
> Really? Wouldn't it be good general practice to store the xlogs on a
> different filesystem - offering one further layer of protection, if
> you will? L
Best practice is to move the xlogs to another filesystem but not for
protection (that i
Really? Wouldn't it be good general practice to store the xlogs on a different
filesystem - offering one further layer of protection, if you will? L
Thanks for your response.
- Original Message -
From: "Tom Lane"
To: "Lou Picciano"
Cc: "pgsql-admin"
Sent: Sunday, November 21, 2
Lou Picciano writes:
> Admin Friends, Can someone tell me the conf variablee to change location of
> binary logs? Would like to store logs in a location other than pg_xlog in
> cluster data dir.
There is no such setting. But if you're so inclined you can make
pg_xlog be a symlink to some othe
Admin Friends, Can someone tell me the conf variablee to change location of
binary logs? Would like to store logs in a location other than pg_xlog in
cluster data dir.
Thanks, Lou
Oh and could we please have the output from SELECT version(); too please.
On Sun, Nov 21, 2010 at 7:56 PM, Matthew Walden wrote:
> A few more information requests if you don't mind.
>
> Can you analyze the table ie "ANALYZE USERS" without error?
>
> Could you please paste the output from "\d+ use
Can you post the select and the exact error?
On Sun, Nov 21, 2010 at 6:43 PM, Lukasz Brodziak
wrote:
> Hello,
>
> I have a problem with one of the tables in my database. The thing is
> that one of the rows is present in corresponding data file yet I'm
> unable to perform any actions on it includi
"Pourghorban.S" wrote:
> I know that I should add a additional column in my data base tables
> that show the level of access of each row. these level types is
> finite.
You need to spend some time with the documentation:
http://www.postgresql.org/docs/current/interactive/index.html
You mi
Found the message but all I get is null value in column
violates non-null constraint. As I said before the tuple is in the
physical file and it contains all the data which is also in other
tuples.
2010/11/21 Lukasz Brodziak :
> Hello,
>
> I have a problem with one of the tables in my database. Th
On Nov 21, 2010, at 1:41 AM, Pourghorban.S wrote:
> yes I know the method for implement, but I do not know where I should
> implement necessary changes
> I know that I should add a additional column in my data base tables that show
> the level of access of each row.
> these level types is
A few more information requests if you don't mind.
Can you analyze the table ie "ANALYZE USERS" without error?
Could you please paste the output from "\d+ users".
And try SELECT COUNT(*) FROM users WHERE id_usr IS NULL;
Is your database large? Can you shut down the instance cleanly and take a
bakkiya raj wrote:
> We are facing a problem with postgresql partition tables. We are
> querying 2 days old partition table and at the same time we are
> dropping 2 months old partition.Sometimes our queries are getting
> failed with "ERROR: could not open relation with OID 1761740". We
> have s
Hello,
I have a problem with one of the tables in my database. The thing is
that one of the rows is present in corresponding data file yet I'm
unable to perform any actions on it including simple SELECT statement.
Is there a way of deleting the tuple from the file by zeroing it and
then reindexing
Dear Scott,
Thank you very much for your answer. But my supervisor told me that I should
add an extra column for all rows in my tables that show the level of access of
each row, when a user gives a query.
Before I saw this link :
http://www.centos.org/docs/5/html/Deployment_Guide-en-US/sec-mls
Hi All,
We are facing a problem with postgresql partition tables. We are querying 2
days old partition table and at the same time we are dropping 2 months old
partition.Sometimes our queries are getting failed with "ERROR: could not
open relation with OID 1761740". We have set the constraint exclu
yes I know the method for implement, but I do not know where I should
implement necessary changes
I know that I should add a additional column in my data base tables that show
the level of access of each row.
these level types is finite.
and by the way I should add to a sql command which
19 matches
Mail list logo
