Re: Database creation taking too long - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Database creation taking too long
Date
Msg-id 5888.1517250910@sss.pgh.pa.us
Whole thread Raw
In response to Database creation taking too long  (Mauricio Alejandro De León Cárdenas <mauricio.deleonc@udem.edu>)
List pgsql-bugs
=?UTF-8?Q?Mauricio_Alejandro_De_Le=C3=B3n_C=C3=A1rdenas?= <mauricio.deleonc@udem.edu> writes:
> Hi, im trying to create a new user within a rails app using the following
> command:
> createuser --createdb --login -P myapp

> It's been running for almost 1 hour but nothing happens (trying to run it
> on windows 10 with git bash). Is this normal?

Sounds like it's blocked on a lock, perhaps.  Try opening another
connection to the DB and snooping around in pg_locks to see what's
blocking it.

            regards, tom lane


pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #14932: SELECT DISTINCT val FROM table gets stuck in aninfinite loop
Next
From: Tom Lane
Date:
Subject: Re: BUG #14932: SELECT DISTINCT val FROM table gets stuck in an infinite loop