Where is blankdatabase backup?

[pedroparkero]

According to this installation guide: http://www.verussolutions.biz/files/WinInstallation.pdf I need to get a file named "blankdatabase2_1.backup" in case of first installation and "restore" the database. But there's no such file inside my downloaded "NGLSelfInstallation2.5.zip". I look around in other guides and I find out that in earlier ones there is a "backupinplain.sql" file but this can be seen on earlier versions of NGL. My question is, should I use that file for this step? And what about the SqlScript1 & 2 SQL files inside the zip? What are they for? Please help as I'm stuck and can't go forward until I'm sure with this. And if it's relevant, I'm using Win7 & PostgreSQL 8.3. Thank you in advance!

[verussolutions]

Hello,

Please download the file from this link
http://sourceforge.net/projects/newgenlib/files/NewGenLib/version2.1/backupinplain.sql/download

The self-installation file has Postgresql 8.0 in it and the self installation was developed for Windows XP.
If you are doing an installation on Windows 7, do not use self-installation rather follow the steps in the Manual.

Also if you are using POstgresql 8.3 or above, in C:/NewGenLibFiles/SystemFiles/Env_var.txt, add this property

POSTGRESQL_VERSION=8.3

[verussolutions]

Hello,

Please download the file from this link
http://sourceforge.net/projects/newgenlib/files/NewGenLib/version2.1/backupinplain.sql/download

The self-installation file has Postgresql 8.0 in it and the self installation was developed for Windows XP.
If you are doing an installation on Windows 7, do not use self-installation rather follow the steps in the Manual.

Also if you are using POstgresql 8.3 or above, in C:/NewGenLibFiles/SystemFiles/Env_var.txt, add this property

POSTGRESQL_VERSION=8.3

[pedroparkero]

Yes, thanks for the quick reply! I only used the self-installer to install the j2sdk and get the contents of jboss and NewGenLib files. Anyway, I did what the manual says. I entered the file in the pgAdmin III restore database setup but I can't click "OK" because it's deactivated. I already tried replacing the file type from "sql" to "backup" but I still can't get it done. Any ideas please?

[pedroparkero]

I found the answer why I can't load the plain sql database. From http://www.pgadmin.org/pgadmin3/faq/ :

pgAdmin III uses PostgreSQL's pg_restore tool, which supports only the COMRESS and TAR options of pg_dump which is used for backup creation. The PLAIN format can't be interpreted by pgAdmin III and pg_restore (it can be edited manually, and executed with psql and pgAdmin III's query tool in many cases), and thus isn't accepted as valid file. We recommend using the COMPRESS format for daily backup tasks. The PLAIN format is for advanced manual processing before executing as SQL script, and has some restrictions (no blobs) which makes it less usable for standard backup tasks.

Since I'm using version 8.3 I need the COMPRESS or TAR backup. So how can I convert the PLAIN format into COMPRESS? Is there already a file for this?

[pedroparkero]

Okay, what I just did is right-click on the database, select "CREATE script", then open the backup sgl file in Wordpad and copy its contents into the SQL Query window. The problem now is I keep getting this error:

ERROR: language "plpgsql" already exists ********** Error ********** ERROR: language "plpgsql" already exists SQL state: 42710

Can anybody have any idea on how I can get past this? Please help...

[verussolutions]

Hi,
Please see the this link
http://newgenlib.2944635.n2.nabble.com/backup-amp-Restore-Newgenlib-td5739218.html#a5739452

This has information to restore a plain(sql) backup

[pedroparkero]

Thanks! I think it works as I have tables in my newgenlib database now according to pgAdmin. But how do I start this thing? I've already run "C:\jboss-3.2.1_tomcat-4.1.24\bin\run.bat" but that only showed a command line. I just want to try it out in my computer first. So localhost is the server for now. Do I have to type "http://localhost:8080/newgenlibctxt/LaunchApplication" in my browser according to the guide to installing client? I tried that but it only made me download a file named "LaunchApplication.jnlp". Does it really have to be Internet Explorer? Sadly I uninstalled that already and I only have Firefox and Chrome...

[verussolutions]

Download the LaunchApplication.jnlp file.
Select it and right click and Open With javaws.exe (Available in your j2sdk1.4.2_xx/jre/javaws directory)

[pedroparkero]

OK, I successfully made Java to load, but after every time I input the server information (server: 127.0.0.1; 8080) it encounters a "critical error" (occurred in NewGenLib server). Any idea what's causing this?