> egrep ‘listen|port’ /usr/local/var/postgres/nfĮgrep: /usr/local/var/postgres/nf: No such file or directory Please log in (using, e.g., “su”) as the (unprivileged) user that will own the server process. Sudo pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start I found that there wasn’t any pg_hba.conf file (only file pg_), so I modified the sample and renamed it (to remover the. > pg_ctl -D /usr/local/var/postgres status Is the server running on host “localhost” and accepting TCP/IP connections on port 5432? The touch was not successful, so I did this instead:īut when I try to start the Ruby on Rails server, I still see this: Sh: /usr/local/var/postgres/server.log: No such file or directory > pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start Here's a screenshot.I had forgotten to run the initdb command. REVOKE ALL ON SCHEMA public FROM postgres Įdit: wow Reddit didn't like something in what I copied. ���miscellaneous����DATABASE�����k���CREATE DATABASE miscellaneous WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' ���STDSTRINGS�����(���SET standard_conforming_strings = 'on' backup if I'm reading it correctly? PGDMP�����/���� backup if it helps - I think it's probably just one database per. Here's a snippet from the beginning of one of those "known good". I'm not sure if there's multiple databases or tables - all I know is they're. I do have a /Library/PostgreSQL/9.5/bin/ though! Nothing relevant in /usr/local/bin either. Thank you for those links! Unfortunately, that first one doesn't help - I don't have a /usr/local/var/postgres or a /usr/local/opt/postgresql. Bonus is I found the service that runs the Postgres server. tl dr was a nuclear uninstall of Resolve. Is there a way to back up all the databases on a server individually without creating a manual list of databases to run through? They've all got the same credentials, if that matters.Įdit to add: I do have pgAdmin installed, and I think Resolve's added a way to restore Postgres databases inside the programĮdit 2: re: downvotes, I understand if this isn't the right place to ask this - where would that be then?Įdit 3: I finally got over my embarrassment and reached out to BMD.How can I restart the server and keep it running through reboots/etc.?.(Probably because the server's not running) I do have backups from before uninstalling the other program, but also need help restoring them. I'm also not sure if this is relevant or not, but I've also got a backup script I'm running: /Library/PostgreSQL/9.5/pgAdmin3.app/Contents/SharedSupport/pg_dump -host localhost -username postgres $dbname -blobs -file "$backuppath"/$_$(date "+%Y_%m_%d_%H_%M").backup -format=custom -verbose -no-password Is the server running locally and acceptingĬonnections on Unix domain socket "/tmp/.s.PGSQL.5432"? Psql: could not connect to server: No such file or directory Here's the screenshots from the program (Resolve), PGAdmin, and the macOS port scanner. Removing any elements from the other program from my $PATH in Terminal.Installing Resolve 16.2.3 and confirming I had "Postgres Server" checked in advanced options (it's bundled in the installer). Uninstalling/Reinstalling Resolve 17.1.1 (which doesn't install Postgres).Installing/Uninstalling/Reinstalling the Resolve 17 Project Server (which installs Postgres).I'm running on macOS Mojave 10.14.6, and here's what I've tried so far: I did make a post on the DaVinci Resolve subreddit, but little/no luck. I uninstalled that program and the other version of Postgres went with it, and now I can't connect to the local Postgres server because it's not running. I had previously installed a version of another color program that uses another version of Postgres for project databases, which wiped out my databases. I use the video program DaVinci Resolve, which uses Postgres 9.5.4 for project databases. Forgive me if this the wrong place to ask or if it's too beginner or niche of a question for this sub.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |