aboutsummaryrefslogtreecommitdiff
path: root/weed/filer/postgres/README.txt
blob: cb0c99c63349f365d0474a23a5027703ff7a26c3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1. create "seaweedfs" database

export PGHOME=/Library/PostgreSQL/10
$PGHOME/bin/createdb --username=postgres --password seaweedfs

2. create "filemeta" table
$PGHOME/bin/psql --username=postgres --password seaweedfs

CREATE TABLE IF NOT EXISTS filemeta (
  dirhash     BIGINT,
  name        VARCHAR(65535),
  directory   VARCHAR(65535),
  meta        bytea,
  PRIMARY KEY (dirhash, name)
);