I'm trying to connect to an h2 in-memory database using the postgresql cli tool. I tried a lot of things, but couldn't authenticate yet. Could someone, please, explain me how to properly start h2 server, which kind of configurations must be done in the web interface (if any) and how to run the psql? I'm experienced in using database CLI tools, H2 and PostgreSQL, but all documentation I find are related to connect to H2 using JDBC connection strings and stuff like that.
Any help is really much appreciated, since I'm already kinda frustrated. Here is what I'm doing: 1 - starting H2 database h2/bin$ bash h2.sh -pg -tcp -web 2 - in the web interface, I connect to 'jdbc:h2:mem:testdb', using 'sa' as username and 'sa' as password 3 - trying to connect with psql $ psql -h localhost -U sa "mem:testdb" Password for user sa: sa psql: FATAL: password authentication failed for user "sa" FATAL: password authentication failed for user "sa" -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
