Re: [GENERAL] How to restore

2015-08-09 Thread Andomar
> > If I have taken any backup successfully through pg_dump? How can I restore > this pg_dump(Sql file) without use of pg_restore. > You can send the file to psql, the command line client: psql yourdb < yourbackup.sql Or: cat yourbackup.sql | psql yourdb Kind regards, Andomar --

Re: [GENERAL] How to restore

2015-08-09 Thread Guillaume Lelarge
Please keep the list in your answers. Le 10 août 2015 7:51 AM, "Sachin Srivastava" a écrit : > > Dear Guillaume, > > What is the syntax of this (psql), kindy confirm. > That can be: psql -f the_file the_database > Regards, > Sachin > > On Mon, Aug 10, 2015 at 11:18 AM, Guillaume Lelarge < guill

Re: [GENERAL] How to restore

2015-08-09 Thread Michael Paquier
On Mon, Aug 10, 2015 at 2:41 PM, Sachin Srivastava wrote: > Dear Team, > > If I have taken any backup successfully through pg_dump? How can I restore > this pg_dump(Sql file) without use of pg_restore. > There is any command line option or through psql, kindly inform to me. The way to restore a b

Re: [GENERAL] How to restore

2015-08-09 Thread Guillaume Lelarge
Hi, Le 10 août 2015 7:43 AM, "Sachin Srivastava" a écrit : > > Dear Team, > > If I have taken any backup successfully through pg_dump? How can I restore this pg_dump(Sql file) without use of pg_restore. > > There is any command line option or through psql, kindly inform to me. > If it's an SQL f

[GENERAL] How to restore

2015-08-09 Thread Sachin Srivastava
Dear Team, If I have taken any backup successfully through pg_dump? How can I restore this pg_dump(Sql file) without use of pg_restore. There is any command line option or through psql, kindly inform to me. Regards, Sachin

Re: [GENERAL] postgres connection

2015-08-09 Thread John R Pierce
On 8/6/2015 6:21 AM, Ramesh T wrote: Hi all, I got a problem when i start postgres server. like' could not connect to the server: connection refused on host 2.3.421.1 and accepting tcp/ip connection on port 5432. any help appreciated.. you could start with telling us what ope

Re: [GENERAL] postgres connection

2015-08-09 Thread Ramesh T
FATAL: syntax error in file "recovery.conf" line 2, near token "config" < 2015-08-07 05:21:13.086 EDT >LOG: startup process (PID 6129) exited with exit code 1 < 2015-08-07 05:21:13.086 EDT >LOG: aborting startup due to startup process failure in pg_log I changed in Recovery.conf restore_comm

Re: [GENERAL] postgres connection

2015-08-09 Thread Ramesh T
any help On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T wrote: > Hi all, > I got a problem when i start postgres server. > like' >could not connect to the server: connection refused on host > 2.3.421.1 and accepting tcp/ip connection on port 5432. > > any help appreciated.. >

Re: [GENERAL] How to intelligently work with views that depend on other views

2015-08-09 Thread Berend Tober
Melvin Davidson wrote: The best solution, IMHO, is don't create views that depend on other views. ... Much better to just make each view a stand alone. Seconding Mr. Davidson's advice. But, given that you are in the situation, here is a workable alternative: Matthew Wilson On Thu, Aug 6,

[GENERAL] postgres connection

2015-08-09 Thread Ramesh T
Hi all, I got a problem when i start postgres server. like' could not connect to the server: connection refused on host 2.3.421.1 and accepting tcp/ip connection on port 5432. any help appreciated..

Re: [GENERAL] official rpm build spec file

2015-08-09 Thread Martín Marqués
El 08/08/15 a las 21:31, AI Rumman escribió: > Hi, > > How to get postgresql official rpm spec file? > Please let me know. I want to build my own Postgresql rpm. You should check the yum pgdg repo. http://yum.postgresql.org/ And here's the git repo, where you will find everything you need to re