PostgreSQLの最近のブログ記事

% brew search postgresql

==> Formulae

postgresql@11    postgresql@12    postgresql@13    postgresql@14    postgresql@15    postgresql@16    postgresql@17    qt-postgresql    postgrest

==> Casks

navicat-for-postgresql                                                        posture-pal

If you meant "postgresql" specifically:

postgresql breaks existing databases on upgrade without human intervention.

See a more specific version to install with:

  brew formulae | grep postgresql@

% brew install postgresql

Warning: Formula postgresql was renamed to postgresql@14.

==> Downloading https://ghcr.io/v2/homebrew/core/postgresql/14/manifests/14.13_3

＜略＞

This formula has created a default database cluster with:

  initdb --locale=C -E UTF-8 /opt/homebrew/var/postgresql@14

To start postgresql@14 now and restart at login:

  brew services start postgresql@14

Or, if you don't want/need a background service you can just run:

  /opt/homebrew/opt/postgresql@14/bin/postgres -D /opt/homebrew/var/postgresql@14

shinoda@shinodamasanorinoMacBook-Air smart_lap % brew services list     

Name          Status User File

postgresql@14 none  

% /opt/homebrew/opt/postgresql@14/bin/postgres -D /opt/homebrew/var/postgresql@14 &

[1] 34533

shinoda@shinodamasanorinoMacBook-Air smart_lap % 2024-11-13 20:40:08.668 JST [34533] LOG:  starting PostgreSQL 14.13 (Homebrew) on aarch64-apple-darwin24.1.0, compiled by Apple clang version 16.0.0 (clang-1600.0.26.4), 64-bit

＜略＞

% psql --version

psql (PostgreSQL) 14.13 (Homebrew)

% brew services start postgresql

Warning: Formula postgresql was renamed to postgresql@14.

==> Successfully started `postgresql@14` (label: homebrew.mxcl.postgresql@14)

% brew services stop postgresql

Warning: Formula postgresql was renamed to postgresql@14.

Stopping `postgresql@14`... (might take a while)

==> Successfully stopped `postgresql@14` (label: homebrew.mxcl.postgresql@14)

% brew --version

zsh: command not found: brew

% /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

==> Checking for `sudo` access (which may request your password)...

Password:＜macOS ユーザのパスワード＞

==> This script will install:

/opt/homebrew/bin/brew

/opt/homebrew/share/doc/homebrew

/opt/homebrew/share/man/man1/brew.1

＜以下略＞

Warning: /opt/homebrew/bin is not in your PATH.

  Instructions on how to configure your shell for Homebrew

  can be found in the 'Next steps' section below.

% echo >> /Users/hogehoge/.zprofile

% echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> /Users/hogehoge/.zprofile

% eval "$(/opt/homebrew/bin/brew shellenv)"

% brew --version

Homebrew 4.4.4

ALTER TABLE table1 ADD col1 CHARACTER VARYING(10)

ALTER TABLE table1 ADD COLUMN col1 CHARACTER VARYING(10)

# -*- coding: utf-8 -*-

# LibreOffice 用マクロ

import uno

def CardRead(*args):

    import nfc

    from nfc.clf import RemoteTarget

    def on_connect(tag):

        doc = XSCRIPTCONTEXT.getDocument()

        sheet = doc.getSheets().getByName('CardMst')

        cell = sheet.getCellByPosition(1,1)

        cell.String = str(tag)

    def main():

        while True:

            with nfc.ContactlessFrontend('usb') as clf:

                clf.connect(rdwr={'on-connect': on_connect})

    main()

com.sun.star.uno.RuntimeException: Error during invoking function CardRead in module file:///C:/Program%20Files/LibreOffice/share/Scripts/python/nfc_get_card_info.py (<class 'usb1.USBErrorAccess'>: LIBUSB_ERROR_ACCESS [-3]

  File "C:\Program Files\LibreOffice\program\pythonscript.py", line 907, in invoke

    ret = self.func( *args )

＜略＞

  File "C:\Users\hoge\AppData\Roaming\Python\Python35\site-packages\usb1\__init__.py", line 125, in raiseUSBError

    raise __STATUS_TO_EXCEPTION_DICT.get(value, __USBError)(value)

)

hogedb=# COPY m_hoge TO '/tmp/m_hoge_20180511.csv' WITH CSV DELIMITER ',' NULL AS '' HEADER FORCE QUOTE *;

ERROR:  syntax error at or near "*"

LINE 1: ...csv' WITH CSV DELIMITER ',' NULL AS '' HEADER FORCE QUOTE *;

hogedb=# COPY m_hoge TO '/tmp/m_hoge_20180511.csv' WITH CSV DELIMITER ',' NULL AS '' HEADER FORCE QUOTE id,name,kubun,hoge1,hoge2,note,cdate,udate;

COPY 84

character 0xfac9 of encoding "EUC_JP" has no equivalent in "UTF8"

 ～

  {0xf4a5, 0xe5879c},

  {0xf4a6, 0xe78699},

  {0x8fa2af, 0xcb98},

  {0x8fa2b0, 0xcb87},

 ～

$ createdb -T old_db new_db

createdb: database creation failed: ERROR:  source database "old_db" is being accessed by other users

$ ps -auxww|grep post

postgres  7186  0.0  0.0  6468 1600 pts/2    S+   14:20   0:00 psql old_db

$ kill -9 7186

ALTER TABLE table_hogehoge ALTER COLUMN column1 TYPE varchar(48);

ERROR:  syntax error at or near "TYPE" at character 46

BEGIN;

ALTER TABLE table_hogehoge ADD COLUMN new_column1 varchar(48);

UPDATE table_hogehoge SET new_column1 = CAST(column1 AS varchar(48));

ALTER TABLE table_hogehoge DROP COLUMN column1;

ALTER TABLE table_hogehoge RENAME COLUMN new_column1 TO column1;

COMMIT;

ALTER TABLE hoge ADD COLUMN chin VARCHAR(1);

ALTER TABLE hoge ADD COLUMN man VARCHAR(1);

ALTER TABLE hoge ADD COLUMN chin VARCHAR(1) NOT NULL;

hoge=# ALTER TABLE hoge ALTER COLUMN chin SET NOT NULL;

ERROR:  column "chin" contains null values

UPDATE hoge SET chin='0', man='0';

ALTER TABLE hoge ALTER COLUMN chin SET NOT NULL;

ALTER TABLE hoge ALTER COLUMN man SET NOT NULL;