Re: Database creation taking too long

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mauricio Alejandro De León Cárdenas <mauricio(dot)deleonc(at)udem(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Database creation taking too long
Date: 2018-01-29 18:35:10
Message-ID: 5888.1517250910@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?UTF-8?Q?Mauricio_Alejandro_De_Le=C3=B3n_C=C3=A1rdenas?= <mauricio(dot)deleonc(at)udem(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-01-29 18:45:10 Re: BUG #14932: SELECT DISTINCT val FROM table gets stuck in an infinite loop
Previous Message Andres Freund 2018-01-29 18:31:18 Re: BUG #14932: SELECT DISTINCT val FROM table gets stuck in an infinite loop