Bye Bye Moore

PoCソルジャーな零細事業主が作業メモを残すブログ

postgresをbrewで入れ直し

postgresをbrewで入れ直し

実際のところ

$ brew cleanup postgresql
$ brew remove postgresql
$ brew install postgresql

DBを新造

$ rm -rf /usr/local/var/postgres
$ initdb /usr/local/var/postgres -E utf8
$ pg_ctl -D /usr/local/var/postgres -l logfile start

必要ならば、

$ createuser -a -d -U postgres -P shuzo_kino
$ psql -l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 | 
...
$ psql postgres
psql (9.5.3)
Type "help" for help.

postgres=#