The -nP options indicate not to include host and port names in the Node Name column and +c 15 increases the command width display, which otherwise defaults to 9: lsof -nP +c 15 | grep LISTEN # no output for 5432 Unfortunately, the output of this command showed the database was not running: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket?Ī further check with lsof (list open files belonging to active processes) confirmed there was no process listening on port 5432, which is the default port used by postgresql. You can connect to the default postgres database as follows: psql -d postgres PostgreSQL comes with psql, a command line tool to interact with the database. The output of this command showed it was successful: => Successfully started `postgresql` (label: ) The Problemīut before pressing the easy button for finding such a quick fix, I wanted to check that a connection worked. So the fix should be simple enough, just start it with the start option of the services subcommand: brew services start postgresql My output showed I had mysql, postgresql, and redis as managed services, but that postgres wasn't started: mysql started dbaron ~/Library/LaunchAgents/ postgresql none redis started dbaron ~/Library/LaunchAgents/ To get information about services that are currently being managed by Homebrew, use the list option of the services subcommand: brew services list However, I couldn't remember whether the database server was running. For production projects, I prefer to setup all databases in Docker containers, but for a simple tutorial, it's fine to use a local service, which I had installed some time ago via brew install postgresql. This all started when I wanted to follow along with a Rails tutorial that required scaffolding a new project with Postgresql as the database. A common usage of the services subcommand is to start and stop databases. In addition to installing, you can also manage services using Homebrew's services subcommand, a wrapper for launchctl. If you work on a Mac, it's likely you use Homebrew to install packages. PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE).This post will cover how to troubleshoot when the postgresql service installed via Homebrew on a Mac isn't starting. Pgcli also supports many of the same environment variables as psql for login options (e.g. warn / -no-warn Warn before running a destructive query. auto-vertical-output Automatically switch to vertical output mode if the result is wider than the terminal width. l, -list list available databases, then exit. prompt-dsn TEXT Prompt format for connections using DSN aliases (Default: " ). prompt TEXT Prompt format (Default: " ). less-chatty Skip intro on startup and goodbye on exit. row-limit INTEGER Set threshold for row limit prompt. list-dsn list of DSN configured into the section of pgclirc file. D, -dsn TEXT Use DSN configured into the section of pgclirc file. d, -dbname TEXT database name to connect to. single-connection Do not use a separate connection for completions. w, -no-password Never prompt for password. u, -user TEXT Username to connect to the postgres database. U, -username TEXT Username to connect to the postgres database. p, -port INTEGER Port number at which the postgres instance is listening. $ pgcli -help Usage: pgcli Options: -h, -host TEXT Host address of the postgres database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |