Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Zdenek Kotala
Richard Huxton wrote: Zdenek Kotala wrote: Richard Huxton wrote: For the rest, that's what ssh is for imho. And what you will do when you don't have ssh access on this machine and 5432 is only one way how to administrate a server? (Windows is another story.) If I've not got ssh access to

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Richard Huxton
Zdenek Kotala wrote: Richard Huxton wrote: For the rest, that's what ssh is for imho. And what you will do when you don't have ssh access on this machine and 5432 is only one way how to administrate a server? (Windows is another story.) If I've not got ssh access to the machine, then I'm

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Dave Page
Zdenek Kotala wrote: >> I believe pgadmin lets you update postgresql.conf remotely, > > IIRC, it is possible only when you have some additional module/function > installed on server and it works only for pgadmin, not for psql. It needs the adminpack contrib module installed in the maintenance DB

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Zdenek Kotala
Richard Huxton wrote: Zdenek Kotala wrote: 3) My personal favorite is create management console - which allows to perform check without physically access to local machine. Management console should be use for another purpose - for example disable/enable databases from cluster, perform upgrade

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Richard Huxton
Zdenek Kotala wrote: 3) My personal favorite is create management console - which allows to perform check without physically access to local machine. Management console should be use for another purpose - for example disable/enable databases from cluster, perform upgrade of datalayer to the new

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-23 Thread Zdenek Kotala
Robert Mach wrote: I see different ways of delivering this functionality to Postgresql. The best of course would be to become part of Postgresql release either as a PostgreSQL command (like UPDATE) or as an postgresql server application like vacuumdb. Other possibility is to create a freesta

Re: [HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-18 Thread Martijn van Oosterhout
On Fri, May 18, 2007 at 12:52:20PM +0200, Robert Mach wrote: > Before presenting possible errors, I divided them into physical and > logical errors. Physical errors will refer to errors in the structure of > pages and tuples, whereas logical errors will depict errors that cause > incorrect perfo

[HACKERS] [GSOC] - I ntegrity check algorithm for data files

2007-05-18 Thread Robert Mach
Hello, my name is Robert Mach and I am happy to by working on GSoC project for Postgresql. The name of the project is Integrity check algorithm for data files in Postgresql. So far, I have put together a list of possible checks for data failure and I would like to hear as much opinions on th