I had the same problem today on Mac Sierra. In Mac Sierra you can find postmaster.pid inside /Users/<user_name>/Library/Application Support/Postgres/var-9.6. Delete postmaster.pid and problem will be fixed.
Modify password for role postgres: sudo -u postgres psql postgres alter user postgres with password ‘postgres’; Now connect to pgadmin using username postgres and password postgres Now you can create roles & databases using pgAdmin How to change PostgreSQL user password?
In pgAdmin, select the required target schema in object tree (databases ->your_db_name -> schemas -> your_target_schema) Click on Plugins/PSQL Console (in top-bar) Write \i /path/to/yourfile.sql Press enter
It’s a valid question don’t know why people feel “doesn’t seem possible to answer that question”. So, here’s how I do what you are trying to do: Pull postgres image from Docker Hub docker pull postgres:latest Run the container using the below command docker run -p 5432:5432 postgres Using docker’s inspect command find the IP … Read more
Right-click on your table and pick option Backup.. On File Options, set Filepath/Filename and pick PLAIN for Format Ignore Dump Options #1 tab In Dump Options #2 tab, check USE INSERT COMMANDS In Dump Options #2 tab, check Use Column Inserts if you want column names in your inserts. Hit Backup button Edit: In case … Read more
Try this : ALTER TABLE table ADD COLUMN col1 int, ADD COLUMN col2 int;
Had the same issue, as its a shared space on AWS with 1000 other DBs. pgAdmin 3 Make sure you are disconnected from your server. Right click your Server -> properties -> Advanced tab. In ‘DB restriction’ type in the name of your database(s) enclosed in single quotes and separated by spaces. E.g. ‘dback447’ pgAdmin … Read more
Open the “Properties” of the Heroku server in pgAdminIII and change the “Maintenance DB” value to be the name of the database you want to connect to. The default setup is suitable for DBAs et al who can connect to any database on the server, but apparently that isn’t true in your case.