2024年11月アーカイブ

% 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)

<asp:Label ID="lblExcelSel" runat="server" Text="Excelファイル"></asp:Label>&nbsp;

<asp:FileUpload ID="fileExcel" runat="server" />&nbsp;

<asp:Button ID="btnUpFile" runat="server" Text="取込" /> 

    ''' <summary>

    ''' 取込ボタン処理

    ''' </summary>

    ''' <param name="sender"></param>

    ''' <param name="e"></param>

    ''' <remarks></remarks>

    Protected Sub btnUpFile_Click(sender As Object, e As EventArgs) Handles btnUpFile.Click

        ' ファイルがアップロードされていなければ終了

        If (fileExcel.HasFile = False) Then Return

        ' ファイルをメモリーに格納

        Dim data(fileExcel.PostedFile.ContentLength - 1) As Byte

        fileExcel.PostedFile.InputStream.Read(data, 0, fileExcel.PostedFile.ContentLength)

        Dim xlsWorkBookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet()

        Dim xlsWorkBook As SpreadsheetGear.IWorkbook = Nothing

        Try

            'メモリからワークブックにセット

            xlsWorkBook = xlsWorkBookSet.Workbooks.OpenFromMemory(data)

        Catch ex As Exception

            alert("Excelファイルを読み込めませんでした。（" + ex.Message + "）")

            Return

        End Try

        Dim currentSheet As SpreadsheetGear.IWorksheet = CType(xlsWorkBook.Worksheets(0), SpreadsheetGear.IWorksheet)

＜以下略＞

% 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)

git --no-optional-locks -c color.branch=false -c color.diff=false -c color.status=false -c diff.mnemonicprefix=false -c core.quotepath=false -c credential.helper=sourcetree push -v --tags origin refs/heads/main:refs/heads/main 

Pushing to ssh://github.com/XXXXXXX/sXXXXXXX.git

git@github.com: Permission denied (publickey).

fatal: Could not read from remote repository.

※ GitHub に登録しているメールアドレスで作成

※ ディフォルトの名前を変更して作成（ケツに GitHub と付ける）

% ssh-keygen -t ed25519 -C "hogehoge@exsample.com"

Generating public/private ed25519 key pair.

Enter file in which to save the key (/Users/hogehoge/.ssh/id_ed25519): /Users/hogehoge/.ssh/id_ed25519_GitHub

Enter passphrase (empty for no passphrase): ＜パスフレーズ＞

Enter same passphrase again: ＜パスフレーズ＞

Your identification has been saved in /Users/hogehoge/.ssh/id_ed25519_GitHub

Your public key has been saved in /Users/hogehoge/.ssh/id_ed25519_GitHub.pub

The key fingerprint is:

SHA256:oKy＜略＞h4 hogehoge@exsample.com

The key's randomart image is:

+--[ED25519 256]--+

|           .=..  |

|           o.+   |

|      .    .=E   |

|   . . . ..++o.  |

|    + o S ..+.+ o|

|   o . + .   = =+|

|  o       .   B.*|

|oo.        . + X+|

|*=.         . =o=|

+----[SHA256]-----+

% eval "$(ssh-agent -s)"

Agent pid 6763

% open ~/.ssh/config

The file /Users/hogehoge/.ssh/config does not exist.

存在していないので空ファイルを作成

% touch ~/.ssh/config

% vi ~/.ssh/config

% cat ~/.ssh/config

Host github.com

  AddKeysToAgent yes

  UseKeychain yes

  IdentityFile ~/.ssh/id_ed25519_GitHub

※ UseKeychain yes 行を書かなければ、キーにパスフレーズを追加しないようにできるらしい

% ssh-add --apple-use-keychain ~/.ssh/id_ed25519_GitHub

Enter passphrase for /Users/hogehoge/.ssh/id_ed25519_GitHub: ＜パスフレーズ＞

Identity added: /Users/hogehoge/.ssh/id_ed25519_GitHub (hogehoge@exsample.com)

% pbcopy < ~/.ssh/id_ed25519_GitHub.pub

※ .pub がついている公開鍵をコピーしよう。俺は .pub のついていない秘密鍵の方をコピーして GitHub から「Key is invalid. You must supply a key in OpenSSH public key format」と叱られた

Web で GitHub にログインし、設定画面を開く→[アクセス] セクションの[SSH キーと GPG キー]を開き、New SSH Key の登録を行う