Site Tools

You are here: Start » PostgreSQL/Postgres

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
postgresql:start [2020-04-19] – external edit 127.0.0.1postgresql:start [2021-10-28] (current) – dcai
Line 1: Line 1:
 ===== PostgreSQL/Postgres ===== ===== PostgreSQL/Postgres =====
  
 +== init data store ==
  
 +''initdb -D /Users/dcai/.local/var/postgres12''
 +
 +== start sever with data store ==
 +''postgres -D ~/.local/var/postgres12/''
 +
 +== create super user ==
 +''createuser -s postgres''
 +
 +== update user password ==
 +
 +''ALTER USER postgres WITH PASSWORD 'xxxxx';''
  
 == Backup == == Backup ==
postgresql/start.1587285307.txt.gz · Last modified: by 127.0.0.1

Page Tools

User Tools