Re: [ADMIN] Diagnose Database Corruption

We don't have a checker because if it is corrupt, it will mention something in the server logs or correct it automatically. Corruption is very rare, usually hardware flakiness. --- [EMAIL PROTECTED] wrote: > Does PostgreSQL

Re: [ADMIN] Disk I/O Monitoring

wrote "Kris Kiger" <[EMAIL PROTECTED]> > Hi all, I'm looking for a good way to monitor disk I/O on a linux > system. Specifically, I would like to know when postgres is making > page-ins and page-outs. If anyone knows of a good utility, please let > me know! Thank you for the help try iosta

Re: [ADMIN] Uninitialized page - fixing

>> recently we are suffering from repeated >> WARNING: Rel pg_toast_77798203: Uninitialized page 25489 - fixing > > Hmm. There is a known mechanism for that to happen in 7.2 and before, > but not in 7.3. Can you see any pattern in the messages? Here is another example: 2003-06-05 21:27:08 WARN

Re: [ADMIN] Uninitialized page - fixing

=?iso-8859-1?Q?Bj=F6rn_Metzdorf?= <[EMAIL PROTECTED]> writes: > recently we are suffering from repeated > WARNING: Rel pg_toast_77798203: Uninitialized page 25489 - fixing Hmm. There is a known mechanism for that to happen in 7.2 and before, but not in 7.3. Can you see any pattern in the messag

Re: [ADMIN] DUMPall PG7.1.3 restore to PG7.3.2

"Eko Pranoto" <[EMAIL PROTECTED]> wrote: > I have error when restoring file DUMPall PG7.1.3 to > PG7.3.2 > with error message "function varchar(integer) does not > exist" > > any one can help ? Postgres 7.3.X is missing of a lot implicit cast present before so I suggest you to define your c

[ADMIN] about pg_hba.conf ?

Dear All. At this moment I want to make the connection with client among server database, where is needed by password to carry out connection At the pg_hba.conf file, on AUTH_type i type MD5. when program is implemented, to emerge orders the error, like this : "The authentication types 5 is NO

Re: [ADMIN] Problem with tcp/ip connection, postgresql.conf

"Nick Fankhauser" <[EMAIL PROTECTED]> writes: > If he starts the postmaster with the -i flag, he can get a connection. > If he sets tcpip_socket = 1 in postgresql.conf, but doesn't use the -i flag > on startup, it doesn't work. > So far, my suggestions have been to make sure the postgresql.conf fi

Re: [ADMIN] Help! Error when calling a function

"Ben Schneider" <[EMAIL PROTECTED]> wrote: > I am receiving the following error when I call a simple function: > Warning: pg_exec() [function.pg-exec > ]: Query failed: ERROR: fmgr_info: function 3036754: cache lookup failed . > in /var/www/html/cmwareben/db

Re: [ADMIN] White Paper

That's a pretty vague question, what kind of information do you need in the white paper? Robert Treat On Thu, 2003-06-05 at 15:49, Terry Hampton wrote: > > All, > > My CEO has asked for a PostgreSQL White Paper > to give to a Client.Before I start t

Re: [ADMIN] unsubscribe

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 05 June 2003 14:38, Vlad Efman wrote: > unsubscribe send an email to [EMAIL PROTECTED], and follow the instructions in the reply. In the future, don't ever post an "unsubscribe" message. You were the one who wanted to subscribe. You wer

Re: [ADMIN] Problem with tcp/ip connection, postgresql.conf

> While experimenting with this, I noted that the postmaster will not > complain if postgresql.conf is not found --- though it will complain if > it finds the file but can't read it (eg permission failures). It seems > to me this is a bug, or at any rate a bad idea. There should be at least > a w

Re: [ADMIN] Diagnose Database Corruption

"Bruce Momjian" <[EMAIL PROTECTED]> wrote: > We don't have a checker because if it is corrupt, it will mention > something in the server logs or correct it automatically. Corruption is > very rare, usually hardware flakiness. I agree about the fact that corruption is very rare but sometimes I got

Re: [ADMIN] What could be the problem?

"Rafael Mauricio González Palacios" <[EMAIL PROTECTED]> wrote: > Hello. > > We had a very serious trouble last week with our databases in Postgres and we > wanna know if maybe someone can help us to find the problem. > > The trouble was that a day some databases in Postgres appear without any row >

[ADMIN] Syncing DBs prior to RServ replication

I'm looking at syncronizing two database servers with RServ (production / "hot standby"), and I'm trying to figure out a way to get the initial database on the slave server syncronized with the master. Normally, I would 1) turn off all clients, 2) dump the database from the master, 3) restore i

Re: [ADMIN] Disk I/O Monitoring

On Friday 06 June 2003 09:42 am, Kris Kiger wrote: > Hi all, I'm looking for a good way to monitor disk I/O on a linux > system. Specifically, I would like to know when postgres is making > page-ins and page-outs. If anyone knows of a good utility, please let > me know! Thank you for the help I