Encore's Blog

Web 开发者 | 专注于WEB应用程序的软件开发人员
Upgrade PostgreSQL from 9.5 to 9.6
数据库 2017-07-03 Encore Shao

Upgrade PostgreSQL from 9.5 to 9.6 # Stop current Postgres server: launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist # Initialize a new 9.6 database: initdb /usr/local/var/postgres9.6 -E utf8 # run pg_upgrade: pg_upgrade -v -d /usr/local/var/postgres -D /usr/local/var/postgres9.6 -b /usr/local/Cellar/postgresql/9.5.4_1/bin/ -B /usr/local/Cellar/postgresql/9.6.1/bin/...

标签: PostgreSQL
How to solve privileges issues when restore PostgreSQL Database
数据库 2017-07-01 邵壮

> sudo -u postgres psql psql (9.6.3) Type "help" for help. postgres=# \du List of roles Role name | Attributes | Member of -----------------+-------------+----------- <user-name> | Superuser | {} : Create DB postgres | Superuser | {} : Create role : Create DB postgres=# alter role <user-name> superuser; ALTER ROLE postgres=#

标签: PostgreSQL
如何创建PostgreSQL Docker Image on Mac
数据库 2017-05-29 邵壮

如何制作PostgreSQL Docker镜像 1. 编写 Dockerfile $ mkdir postgres9.6; cd postgres9.6 $ cat Dockerfile # vim:set ft=dockerfile: FROM ubuntu # MAINTAINER SvenDowideit@docker.com # Add the PostgreSQL PGP key to verify their Debian packages. # It should be the same key as https://www.postgresql.org/media/keys/ACCC4CF8.asc RUN apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B...

标签: Docker PostgreSQL
This website uses cookies to ensure you get the best experience on our website.
Got it!