Can´t populate my database OMERO4.1_0 sql

[NUser]

Hello,
i like to test the omero system on windows xp for my chef and I don´t work with any of the prequesites (like PostgreSql etc. ) before.
I have create the database script (as you can see on the picture) and it was saved at C:\omero\omero_dist\bin.
At the installation script for windows I have to populate the database with \i /omero... and I try it. But I only get the message "No such file or directory" as you can see on the second picture.
How can I find the file or how can I change the path so that the command \i .. was working?
Thank you

[jmoore]

As you said, the SQL script was created in "C:\omero\omero_dist\bin" but the PSQL shell started in "C:\Programme\PostgreSQL\8.3\bin". When you type "\i OMERO4.1__0.sql" it looks for the file in the PostgreSQL directory. Try using the full path to the file.

Hope that helps,
~Josh

[NUser]

the full path is C:\omero\omero_dist\bin\OMERO4.1_0.sql
I´ve tried some variants:
omero=> \i /C:/omero/...
omero=> \i /C:\omero\omero_dist\bin/OMERO4.1_0sql
But I get only "No such file or directory"
"/C: inalid argument"
or permission denied
It could be the backslashes.
Can I save the OMERO4.1_0.sql to another path so that PostgreSQL/bin can find it?

Thanks

[jmoore]

Sure, you can either move the file yourself with "move OMERO4.1__0.sql C:\Programme\PostgreSQL\8.3\bin" or you can have it created in your current directory via:

Code: Select all

cd c:\Programme\PostgreSQL\8.3\bin
C:\omero\omero_dist\bin\omero db script


Cheers,
~Josh

[NUser]

If I try it

Code: Select all

C:\omero\omero_dist\bin\omero db script

I get the line
"The command "python" could not be found

Could it have something to to with the enviroment variables path and PYTHONPATH?

[NUser]

Thank you very much for your help, cause I´m such a amateur.

[jmoore]

Yes, with the PATH variable. I'm not sure of how you've configured your PATH, so it's probably easiest to move the SQL script into your PostgreSQL directory. Then, you should then be able to use "\i OMERO4.1__0.sql". Alternatively, you should be able to use:

Code: Select all

\i /omero/omero_dist/bin/OMERO4.1__0.sql


as long as the file is on the same drive (C:), which it is.

Cheers,
~Josh

[NUser]

It´s so frustrating.
Now I´ve changed the PATH so I could use

Code: Select all

C:\omero\omero_dist\bin\omero db script

And as you can see it was saved to C:\Programme\PostgreSQL\8.3\bin\OMERO4.1_0.sql
No I have on version in this path and one in C:\omero\omero_dist\bin\OMERO4.1_0.sql
Then I tried different versions of \i ... as you can see at the second picture, but I get the message "No such file or directory" again.
Actually it has to be work or not?
Kind regards

[NUser]

the other picture

[jmoore]

I think the problem is that you are only using one underscore: The file has two "__" (which looks the same as "_"). ~J