Wednesday, May 26, 2010

How to dump postgres database

1. use pg_dump to dump database
pg_dump dbname | gzip > filename.gz

2. The restore it
createdb dbname
gunzip -c filename.gz | psql dbname



How to install an application in linux using tar.gz file

1. copy in a suitable location mainly /usr/local/ then run following command
tar -zxvf .tar.gz

2. change dir to /usr/local/

3. run ./configure --help

4. set appropriate options and run ./configure --[options]

5. run command make

6. if available run make test

7. at last run make install

8. here you have done

9. set the PATH to include the lib files of above application

10 Good luck