public inbox for [email protected]  

help / color / mirror / Atom feed

[Pljava-dev] ERROR: schema "sqlj" does not exist
3+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] ERROR: schema "sqlj" does not exist
@ 2008-10-17 14:08 
  2008-10-17 15:52 ` [Pljava-dev] ERROR: schema "sqlj" does not exist 
  0 siblings, 1 reply; 3+ messages in thread

From:  @ 2008-10-17 14:08 UTC (permalink / raw)

Hi there,

This is my first time installing pljava.  I unziped the
"pljava-i686-pc-linux-gnu-pg8.1-1.4.0.tar" to /usr/pljava directory.
I modified
the postgresql.conf file and added the following lines

dynamic_library_path ='$libdir:/usr/pljava'

custom_variable_classes = 'pljava'
pljava.classpath='/usr/pljava/pljava.jar'

And restarted the postgres service.  After that I tried to run the
sample tests given in the wiki.   But, I am getting the following
error message
ERROR:  schema "sqlj" does not exist in the postgres log file.  What is wrong?

Thank you.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] ERROR: schema "sqlj" does not exist
  2008-10-17 14:08 [Pljava-dev] ERROR: schema "sqlj" does not exist 
@ 2008-10-17 15:52 ` 
  2008-10-17 20:22   ` [Pljava-dev] ERROR: schema "sqlj" does not exist 
  0 siblings, 1 reply; 3+ messages in thread

From:  @ 2008-10-17 15:52 UTC (permalink / raw)

Hi there,

I tried to install using the deploy.jar and now I am getting the
following error.

java.sql.SQLException: You must be a superuser to deploy/undeploy pl/Java.
        at org.postgresql.pljava.deploy.Deployer.checkIfConnectedAsSuperuser(Deployer.java:303)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:257)

I am logged in as root.




On Fri, Oct 17, 2008 at 10:08 AM, Nelli Vanan <ambulimama at gmail.com> wrote:
> Hi there,
>
> This is my first time installing pljava.  I unziped the
> "pljava-i686-pc-linux-gnu-pg8.1-1.4.0.tar" to /usr/pljava directory.
> I modified
> the postgresql.conf file and added the following lines
>
> dynamic_library_path ='$libdir:/usr/pljava'
>
> custom_variable_classes = 'pljava'
> pljava.classpath='/usr/pljava/pljava.jar'
>
> And restarted the postgres service.  After that I tried to run the
> sample tests given in the wiki.   But, I am getting the following
> error message
> ERROR:  schema "sqlj" does not exist in the postgres log file.  What is wrong?
>
> Thank you.
>




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] ERROR: schema "sqlj" does not exist
  2008-10-17 14:08 [Pljava-dev] ERROR: schema "sqlj" does not exist 
  2008-10-17 15:52 ` [Pljava-dev] ERROR: schema "sqlj" does not exist 
@ 2008-10-17 20:22   ` 
  0 siblings, 0 replies; 3+ messages in thread

From:  @ 2008-10-17 20:22 UTC (permalink / raw)

Nelli Vanan wrote:
> 
> java.sql.SQLException: You must be a superuser to deploy/undeploy pl/Java.
>         at org.postgresql.pljava.deploy.Deployer.checkIfConnectedAsSuperuser(Deployer.java:303)
>         at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:257)
> 
> I am logged in as root.
> 

You need to connect to the database as a database superuser.  The shell 
user the deployer is run from is not relevent.

Kris Jurka






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2008-10-17 20:22 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-17 14:08 [Pljava-dev] ERROR: schema "sqlj" does not exist 
2008-10-17 15:52 ` 
2008-10-17 20:22   ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox