Connections, and DB locking?

[Pablo Meier]

Hi friends!

Big thanks to all who work on epgsql, I'm using it in my Erlang project and enjoying it a great deal :)

I have a question that might be more Postgres territory rather than epgsql proper, but — if my web app is running (and maintaining a connection to Postgres), I can't do other operations on the database from psql in another tmux tab. For reference, I'm creating the connection in a gen_server's `init` and maintaining it in the state, as well as preparing a number of Statements that have been parsed ahead of time, and binding/executing as necessary in each request.

Is there a way to prevent this lock-up from happening?

Happy to answer any other questions, and thanks for your time! :D

-Pablo

[David Welton]

Hi,

That sounds like a Postgres problem to me. Can you open two psql's at
the same time?

> --
> You received this message because you are subscribed to the Google Groups
> "Erlang epgsql Postgres driver use and development" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to epgsql+un...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--
David N. Welton

http://www.welton.it/davidw/

http://www.dedasys.com/