Hi,
 
I get the error "FATAL: Database "xxx" does not exist" when trying to connect 
to the database using JDBC. The superuser "postgres" owns my database and 
tables. However, it seems I can only connect to the database when the username 
matches the name of the database I am connecting to. I can't connect to the 
database as the superuser postgres who owns the database. For example, if my 
database were named "Trudy", I can only connect with a user named "Trudy".
 
The Java code I'm using to connect looks something like this:
 
  try{
         //Register the JDBC driver for PostgreSQL.
         Class.forName(driverType);
               
         //Get a connection to the database
         Connection conn = DriverManager.getConnection(url, username, password);
         PreparedStatement ps = 
             conn.prepareStatement(jsassql);
           ps.execute();
           conn.close();
      }
      catch(Exception e){
         e.printStackTrace();
      } 
 
Is there anyway to fix the access so I can use a superuser other than the one 
named after the database?
 

Reply via email to