postgres with columns's longnames 512-bit

2022 03 19 + published on https://github.com/InstallAndUse/Daily /A

download stable source from https://www.postgresql.org/ftp/source/

cd Downloads tar -xzvf postgresql-12.4.tar.gz vi src/include/pg_config_manual.h

#define NAMEDATALEN 512

./configure

download and install xcode

make su make install

/usr/sbin/sysadminctl -addUser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

console

/usr/local/pgsql/bin/psql

create user (match OS's username) and give rights

CREATE USER (you)

from another terminal, should work

/usr/local/pgsql/bin/psql -U postgres postgres

include into PATHs

su vi /etc/paths

/usr/local/pgsql/bin

Books:

Anton's bookshelf

PostgreSQL_with_long_names@MacOS.md 918 B Permalink History Raw