question about timezone in postgresql+java?

Question

I am using postgresql9.0 and JDK6. I am running pg_controldata command in postgresql. in that I need "Time of latest checkpoint:" value. it is a date & time with timezone.

while running through java API it is dispalying everything otherthan timezone.

from direct postgres it it showing ---Time of latest checkpoint:Mon 12 Mar 2012 08:15:43 AM SGT

but when run through code then it is showing----Time of latest checkpoint:Mon Mar 12 08:15:43 2012

how to solve it?

String result = 
pe.executepsql("/data/PostgreSQL/bin/pg_controldata /data/PostgreSQL/data"); 
System.out.println("Output of cmd:" +result); 
String start = "Time of latest checkpoint:"; 
String end = "Minimum recovery ending location:"; 
String str = result.substring(result.indexOf(start)+
"Time of latest checkpoint:".length(),result.indexOf(end)).trim(); 
System.out.println("Time of latest checkpoint: " +str); 
executepsql()

is used to execute postgres command.

executepsql() is used to execute postgres command.

I tried psql -c command also with this method which is working fine. but pg_controldata is not working correctly.

String result = pe.executepsql("/data/PostgreSQL/bin/pg_controldata /data/PostgreSQL/data"); System.out.println("Output of cmd:" +result); String start = "Time of latest checkpoint:"; String end = "Minimum recovery ending location:"; String str = result.substring(result.indexOf(start)+"Time of latest checkpoint:".length(),result.indexOf(end)).trim(); System.out.println("Time of latest checkpoint: " +str); executepsql() is used to execute postgres command. — Anjali
– Anjali, Commented May 18, 2011 at 4:14

Nishant · Accepted Answer · 2011-05-18 05:35:21Z

1

String result = pe.executepsql("/data/PostgreSQL/bin/pg_controldata /data/PostgreSQL/data");
System.out.println("Output of cmd:" +result);
String start = "Time of latest checkpoint:";
String end = "Minimum recovery ending location:";
String str = result.substring(result.indexOf(start)+"Time of latest checkpoint:".length(),result.indexOf(end)).trim();
System.out.println("Time of latest checkpoint: " +str);

executepsql() is used to execute postgres command.

I tried psql -c command also with this method which is working fine. but pg_controldata is not working correctly.

edited May 18, 2011 at 5:35

Nishant

3,01524 silver badges38 bronze badges

answered May 18, 2011 at 4:57

Anjali

1,7115 gold badges31 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

question about timezone in postgresql+java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related