Can't Run 'create_postgresql' Get Permission Denied

[scowles]

When I try to run the command \i d:\winids\barnyard2\schemas\create_postgresql;

or try to run any of the other \i commands under the install tutorial heading of "Creating the Windows Intrusion Detection System Database Tables "

the result is always "d:: Permission denied"

I've tried many things to try and get around this blockage but I've not been successful.  Any suggestions would be appreciated.

Edited May 14, 2015 by scowles

[Morpheus]

Try reversing the slashes:

Change from: \i d:\winids\barnyard2\schemas\create_postgresql;

Change to:  \i d:/winids/barnyard2/schemas/create_postgresql;

Let me know if that works...

Can you also try removing the ; at the end to see if it works?

Edited May 14, 2015 by Morpheus

[scowles]

Thank you.  Reversing the slashes as you suggested and keeping the semi-colon worked...so far

 

Edited May 14, 2015 by scowles
Next problem I may be able to resolve on my own

[scowles]

One more command under the install tutorial heading of "Creating the Windows Intrusion Detection System Database Tables "

\i d:/temp/snort_user.sql;

the result is

WARNING: sequence "reference_ref_id_seq" only supports USAGE, SELECT, and UPDATE privileges

but after that I get

GRANT

Is that the expected result?

 

[Morpheus]

One more command under the install tutorial heading of "Creating the Windows Intrusion Detection System Database Tables "

\i d:/temp/snort_user.sql;

the result is

WARNING: sequence "reference_ref_id_seq" only supports USAGE, SELECT, and UPDATE privileges

but after that I get

GRANT

Is that the expected result?

 

​I'm not sure, but its a warning and can be ignored.