Re: pg_start_backup question

Le samedi 31 octobre 2009 à 00:39:54, db de a écrit :
> Below is what I did:
> I opened a super user connection to creat a super user statement. Then use
> the super user statement to execute "SELECT pg_start_backup('label')".
>
> try
> {
> superuserCont = java.sql.DriverManager.getConnection(URL, su,
> suPassword);
> suStatement = superuserCont.createStatement();
> boolean ret = suStatement.execute("SELECT
> pg_start_backup('label')"); //LINE1
> }
> catch(SQLException e)
> {
> System.out.println("exception");
>
> //LINE2
> }
> finally
> {
> System.out.println("ret:" +
> ret);
> //LINE3
> }
>
> After LINE1 is executed, LINE3 is run and the output is: ret:false. LINE2
> is not executed.
>

Which PostgreSQL release do you use? did you activate archive_mode? what's in
your archive_command?

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com