'
```
---
### Author:  [@NateDhaliwal](https://meta.discourse.org/u/NateDhaliwal)
#### Post date: [15 בינואר, 2026, 12:22pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/2 "2026-01-15T12:22:14Z")
Is there a reason why you don’t want to use `./launcher rebuild app`?
(Also, that looks like the dev environment’s `bin/rails db:migrate` command)
---
### Author:  [@sniper756](https://meta.discourse.org/u/sniper756)
#### Post date: [15 בינואר, 2026, 12:27pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/3 "2026-01-15T12:27:39Z")
Problems encountered when querying the database
> [@Migration error in 'rename\_discourse\_rewind\_disabled\_to\_enabled'](https://meta.discourse.org/t/migration-error-in-rename-discourse-rewind-disabled-to-enabled/393049/19?u=sniper756):
>
> @here for those who are having issues, I think @david and I may have found the root cause but [it’s complicated](https://github.com/discourse/discourse/pull/37037) to reproduce locally. Could any of you run the following SQL queries and report the results here? Query #1 SELECT table\_schema, column\_name, column\_default FROM information\_schema.columns WHERE table\_name = 'user\_options' AND column\_name = 'discourse\_rewind\_disabled' ORDER BY table\_schema; Query #2 SELECT n.nspname, n.oid FROM pg\_namespace n JOIN pg\_class c ON c.relnamespace = n.o…
---
### Author:  [@sniper756](https://meta.discourse.org/u/sniper756)
#### Post date: [15 בינואר, 2026, 12:32pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/4 "2026-01-15T12:32:40Z")
./launcher rebuild app no problem
---
### Author:  [@sniper756](https://meta.discourse.org/u/sniper756)
#### Post date: [15 בינואר, 2026, 12:58pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/5 "2026-01-15T12:58:38Z")
I found **a way to query Discourse database information**
1. Enter the container
```bash
./launcher enter app
```
1. Switch to the postgres user in the container and start psql
```bash
sudo -u postgres psql discourse
```
Now the terminal becomes
```plaintext
discourse=#
```
1. See what tables there are
```sql
\dt
```
1. Exit psql
```sql
\q
```
---
### Author:  [@sniper756](https://meta.discourse.org/u/sniper756)
#### Post date: [15 בינואר, 2026, 1:02pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/7 "2026-01-15T13:02:45Z")
Is this error normal? ~~~~~~~~~~~~~~~~~~~
> [@运行bin/rails db 出现错误](https://meta.discourse.org/t/bin-rails-db/393531?u=sniper756):
>
> 容器中以discourse用户运行bin/rails db 出现错误。已经重新安装Ubuntu，重新安装部署discourse，仍然出错。 discourse@jerry-app:~$ cd /var/www/discourse discourse@jerry-app:/var/www/discourse$ bin/rails db /usr/local/lib/ruby/gems/3.3.0/gems/bundler-2.6.4/lib/bundler/runtime.rb:71:in `rescue in block (2 levels) in require': There was an error while trying to load the gem 'debug/prelude'. (Bundler::GemRequireError) Gem Load Error is: cannot load such file -- debug/prelude Backtrace for gem load error is: \
### Author:  [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [15 בינואר, 2026, 1:32pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/8 "2026-01-15T13:32:57Z")
Try `sudo -u postgres psql discourse`?
What are you trying to achieve with that, by the way? Adding context when looking for help is always appreciated.
---
### Author:  [@sniper756](https://meta.discourse.org/u/sniper756)
#### Post date: [15 בינואר, 2026, 2:53pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/9 "2026-01-15T14:53:39Z")
Query information in the postgres database.
Provide feedback for the following post
> [@Migration error in 'rename\_discourse\_rewind\_disabled\_to\_enabled'](https://meta.discourse.org/t/migration-error-in-rename-discourse-rewind-disabled-to-enabled/393049/19?u=sniper756):
>
> @here for those who are having issues, I think @david and I may have found the root cause but [it’s complicated](https://github.com/discourse/discourse/pull/37037) to reproduce locally. Could any of you run the following SQL queries and report the results here? Query #1 SELECT table\_schema, column\_name, column\_default FROM information\_schema.columns WHERE table\_name = 'user\_options' AND column\_name = 'discourse\_rewind\_disabled' ORDER BY table\_schema; Query #2 SELECT n.nspname, n.oid FROM pg\_namespace n JOIN pg\_class c ON c.relnamespace = n.o…
---
### Author:  [@sniper756](https://meta.discourse.org/u/sniper756)
#### Post date: [15 בינואר, 2026, 2:55pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/10 "2026-01-15T14:55:22Z")
I cannot access the database using the method described by zogstrip
> [@Migration error in 'rename\_discourse\_rewind\_disabled\_to\_enabled'](https://meta.discourse.org/t/migration-error-in-rename-discourse-rewind-disabled-to-enabled/393049/22?u=sniper756):
>
> When inside the container, as the discourse user, at the root of the discourse directory, you can run bin/rails db to connect to the right db.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [15 בינואר, 2026, 4:18pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/11 "2026-01-15T16:18:23Z")
If you want to get to the database on a [standard install](https://meta.discourse.org/t/142537?silent=true), the way that I do it is
```plaintext
./launcher enter app
su postgres
psql discourse
```
I’ve not seen `bin/rails db`, but when I ran it on one container (that uses an external database) I got a prompt asking for a password for user discourse.
---
### Author:  [@supermathie](https://meta.discourse.org/u/supermathie)
#### Post date: [15 בינואר, 2026, 7:40pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/12 "2026-01-15T19:40:54Z")
> [@pfaffman](#):
>
> I’ve not seen `bin/rails db`
It’s an alias for [`rails dbconsole`](https://guides.rubyonrails.org/command_line.html#bin-rails-dbconsole)
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [14 בפברואר, 2026, 7:41pm UTC](https://meta.discourse.org/t/bin-rails-db/393531/13 "2026-02-14T19:41:38Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.