On 26/07/2007 15:22, Mahmood Ali wrote:

> thanks for reply the Administrative -> Tools ->
> Services - is unable to start. my topic is that how
> can we recover data from any postgres sql without
> restore backup.

Hi Mahmood,

Please send replies to the list also, so others can benefit.

Have you tried connecting from the command line, on the server box, with
psql? - in order to establish whether the server is actually running.

psql -U <username> -p <port, if not 5432> <databasename>

Assuming that you can connect in this way, use pg_dump to create a text
dump file of the data.

pg_dump -U <username> -p <port, if not 5432> -d <database> -f <filename>

HTH,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match