2.0.5 Postgres sample cannot be restored

Hi devs,

The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin

When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine

Also after the command-line restore gives the following exception on login:

Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430
···

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

Saptarshi,

The file on dhis2.org is a plain text sql dump, despite the name .backup, and not a compressed pgadmin backup. I haven’t tried to restore that in pgadmin, but there might be a problem with that, not sure.

Have you tried to restore this plain text dump from the command line?

A compressed backup of the same database is available here:

http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup

Ola,

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi devs,

The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin

When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine

Also after the command-line restore gives the following exception on login:

Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Hi,

Sorry, what I meant to say is that you should try to load/import this dump file using the psql command and not pg_restore (which pgAdmin uses).

Try:

$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Saptarshi,

The file on dhis2.org is a plain text sql dump, despite the name .backup, and not a compressed pgadmin backup. I haven’t tried to restore that in pgadmin, but there might be a problem with that, not sure.

Have you tried to restore this plain text dump from the command line?

A compressed backup of the same database is available here:

http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup

Ola,


Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi devs,

The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin

When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine

Also after the command-line restore gives the following exception on login:

Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Like I wrote in the first email, the command line restore works fine, but then gives the exception

Then after I clear the usersetting table, the exception goes away.

Adding a new report to view in the dashboard (i.e. changes the usersetting) again throws the exception… Until cleared again, keeps throwing the exception!

···

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi,

Sorry, what I meant to say is that you should try to load/import this dump file using the psql command and not pg_restore (which pgAdmin uses).

Try:

$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql


Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Saptarshi,

The file on dhis2.org is a plain text sql dump, despite the name .backup, and not a compressed pgadmin backup. I haven’t tried to restore that in pgadmin, but there might be a problem with that, not sure.

Have you tried to restore this plain text dump from the command line?

A compressed backup of the same database is available here:

http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup

Ola,


Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Hi devs,

The sample database backup for 2.0.5 at http://dhis2.org/downloads cannot be restored using pgadmin

When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some say that plan backups cannot be restored, compressed ones work fine

Also after the command-line restore gives the following exception on login:

Exception (org.hibernate.type.SerializationException): could not deserialize
Caused by (java.io.StreamCorruptedException): invalid stream header: BB656430

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Just replaced my Postgres JDBC driver with
http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar
and this error does not seem to happen. I can enter the GIS and modify
user settings.

Seems there is level of incompatibility between the version currently
included with 2.0.5 and Postgres 9.

Regards,
Jason

···

On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha <sunbiz@gmail.com> wrote:

Like I wrote in the first email, the command line restore works fine, but
then gives the exception
Then after I clear the usersetting table, the exception goes away.
Adding a new report to view in the dashboard (i.e. changes the usersetting)
again throws the exception... Until cleared again, keeps throwing the
exception!
---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

On 10 November 2010 23:43, Ola Hodne Titlestad <olati@ifi.uio.no> wrote:

Hi,
Sorry, what I meant to say is that you should try to load/import this dump
file using the psql command and not pg_restore (which pgAdmin uses).
Try:
$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 23:27, Ola Hodne Titlestad <olati@ifi.uio.no> wrote:

Saptarshi,
The file on dhis2.org is a plain text sql dump, despite the name .backup,
and not a compressed pgadmin backup. I haven't tried to restore that in
pgadmin, but there might be a problem with that, not sure.
Have you tried to restore this plain text dump from the command line?
A compressed backup of the same database is available here:
http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup
Ola,

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 14:50, Saptarshi Purkayastha <sunbiz@gmail.com> >>> wrote:

Hi devs,
The sample database backup for 2.0.5 at
http://dhis2.org/downloads cannot be restored using pgadmin
When using pgadmin the 'OK' button stays gray. I've tried this and some
say that plan backups cannot be restored, compressed ones work fine
Also after the command-line restore gives the following exception on
login:

Exception (org.hibernate.type.SerializationException): could not
deserialize

Caused by (java.io.StreamCorruptedException): invalid stream header:
BB656430

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

For the record, both 2.0.5 and trunk has been updated with latest postgres jdbc driver.

The WAR file on dhis2.org is updated regularly as minor bugs/updates are done:

http://dhis2.org/download/dhis2-2.0.5.war

Lars

···

On Thu, Nov 11, 2010 at 9:48 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Just replaced my Postgres JDBC driver with

http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar

and this error does not seem to happen. I can enter the GIS and modify

user settings.

Seems there is level of incompatibility between the version currently

included with 2.0.5 and Postgres 9.

Regards,

Jason

On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha > sunbiz@gmail.com wrote:

Like I wrote in the first email, the command line restore works fine, but

then gives the exception

Then after I clear the usersetting table, the exception goes away.

Adding a new report to view in the dashboard (i.e. changes the usersetting)

again throws the exception… Until cleared again, keeps throwing the

exception!


Regards,

Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi,

Sorry, what I meant to say is that you should try to load/import this dump

file using the psql command and not pg_restore (which pgAdmin uses).

Try:

$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql


Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Saptarshi,

The file on dhis2.org is a plain text sql dump, despite the name .backup,

and not a compressed pgadmin backup. I haven’t tried to restore that in

pgadmin, but there might be a problem with that, not sure.

Have you tried to restore this plain text dump from the command line?

A compressed backup of the same database is available here:

http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup

Ola,


Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com > > >>> wrote:

Hi devs,

The sample database backup for 2.0.5 at

http://dhis2.org/downloads cannot be restored using pgadmin

When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some

say that plan backups cannot be restored, compressed ones work fine

Also after the command-line restore gives the following exception on

login:

Exception (org.hibernate.type.SerializationException): could not

deserialize

Caused by (java.io.StreamCorruptedException): invalid stream header:

BB656430


Regards,

Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+260968395190


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Should it be called 2.0.5. based on the branch revision??

Just my 2 cents

···

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2010/11/18 Lars Helge Øverland larshelge@gmail.com

For the record, both 2.0.5 and trunk has been updated with latest postgres jdbc driver.

The WAR file on dhis2.org is updated regularly as minor bugs/updates are done:

http://dhis2.org/download/dhis2-2.0.5.war

Lars

On Thu, Nov 11, 2010 at 9:48 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Just replaced my Postgres JDBC driver with

http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar

and this error does not seem to happen. I can enter the GIS and modify

user settings.

Seems there is level of incompatibility between the version currently

included with 2.0.5 and Postgres 9.

Regards,

Jason

On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha > > sunbiz@gmail.com wrote:

Like I wrote in the first email, the command line restore works fine, but

then gives the exception

Then after I clear the usersetting table, the exception goes away.

Adding a new report to view in the dashboard (i.e. changes the usersetting)

again throws the exception… Until cleared again, keeps throwing the

exception!


Regards,

Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi,

Sorry, what I meant to say is that you should try to load/import this dump

file using the psql command and not pg_restore (which pgAdmin uses).

Try:

$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql


Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Saptarshi,

The file on dhis2.org is a plain text sql dump, despite the name .backup,

and not a compressed pgadmin backup. I haven’t tried to restore that in

pgadmin, but there might be a problem with that, not sure.

Have you tried to restore this plain text dump from the command line?

A compressed backup of the same database is available here:

http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup

Ola,


Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com > > > > >>> wrote:

Hi devs,

The sample database backup for 2.0.5 at

http://dhis2.org/downloads cannot be restored using pgadmin

When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some

say that plan backups cannot be restored, compressed ones work fine

Also after the command-line restore gives the following exception on

login:

Exception (org.hibernate.type.SerializationException): could not

deserialize

Caused by (java.io.StreamCorruptedException): invalid stream header:

BB656430


Regards,

Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+260968395190


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Should it be called 2.0.5. based on the branch revision??
Just my 2 cents

I don’t think its worth the effort… We can always get the revision from the About page…

···

2010/11/18 Saptarshi Purkayastha sunbiz@gmail.com


Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

2010/11/18 Lars Helge Øverland larshelge@gmail.com

For the record, both 2.0.5 and trunk has been updated with latest postgres jdbc driver.

The WAR file on dhis2.org is updated regularly as minor bugs/updates are done:

http://dhis2.org/download/dhis2-2.0.5.war

Lars

On Thu, Nov 11, 2010 at 9:48 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Just replaced my Postgres JDBC driver with

http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar

and this error does not seem to happen. I can enter the GIS and modify

user settings.

Seems there is level of incompatibility between the version currently

included with 2.0.5 and Postgres 9.

Regards,

Jason

On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha > > > sunbiz@gmail.com wrote:

Like I wrote in the first email, the command line restore works fine, but

then gives the exception

Then after I clear the usersetting table, the exception goes away.

Adding a new report to view in the dashboard (i.e. changes the usersetting)

again throws the exception… Until cleared again, keeps throwing the

exception!


Regards,

Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

On 10 November 2010 23:43, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi,

Sorry, what I meant to say is that you should try to load/import this dump

file using the psql command and not pg_restore (which pgAdmin uses).

Try:

$psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql


Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 23:27, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Saptarshi,

The file on dhis2.org is a plain text sql dump, despite the name .backup,

and not a compressed pgadmin backup. I haven’t tried to restore that in

pgadmin, but there might be a problem with that, not sure.

Have you tried to restore this plain text dump from the command line?

A compressed backup of the same database is available here:

http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup

Ola,


Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 10 November 2010 14:50, Saptarshi Purkayastha sunbiz@gmail.com > > > > > > >>> wrote:

Hi devs,

The sample database backup for 2.0.5 at

http://dhis2.org/downloads cannot be restored using pgadmin

When using pgadmin the ‘OK’ button stays gray. I’ve tried this and some

say that plan backups cannot be restored, compressed ones work fine

Also after the command-line restore gives the following exception on

login:

Exception (org.hibernate.type.SerializationException): could not

deserialize

Caused by (java.io.StreamCorruptedException): invalid stream header:

BB656430


Regards,

Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+260968395190


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp