No comments here? :(

Em quarta-feira, 13 de agosto de 2014 19h17min28s UTC-3, Thiago Lima 
escreveu:
>
> 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.

Reply via email to