The error states that the psql utility can’t find the socket to connect to your database server. Either you don’t have the database service running in the background, or the socket is located elsewhere, or perhaps the pg_hba.conf needs to be fixed. Step 1: Verify that the database is running The command may vary depending … Read more
Thanks a lot Craig Ringer, works, finally works! You are my new idool now! The steps are: open the cmd SET PGCLIENTENCODING=utf-8 chcp 65001 psql -h your.ip.addr.ess -U postgres
It appears that your package manager failed to create the database named $user for you. The reason that psql -d template1 works for you is that template1 is a database created by postgres itself, and is present on all installations. You are apparently able to log in to template1, so you must have some rights … Read more
cd /etc/postgresql/9.x/main/ open file named postgresql.conf sudo vi postgresql.conf add this line to that file listen_addresses=”*” then open file named pg_hba.conf sudo vi pg_hba.conf and add this line to that file host all all 0.0.0.0/0 md5 It allows access to all databases for all users with an encrypted password restart your server sudo /etc/init.d/postgresql restart
You may wish to read a summary of the ways to authenticate to PostgreSQL. To answer your question, there are several ways provide a password for password-based authentication: Via the password prompt. Example: psql -h uta.biocommons.org -U foo Password for user foo: In a pgpass file. See libpq-pgpass. Format: <host>:<port>:<database>:<user>:<password> With the PGPASSWORD environment variable. … Read more
In PostgreSQL, you can use the \connect meta-command of the client tool psql: \connect DBNAME or in short: \c DBNAME
Of course, you will get a fatal error for authenticating, because you do not include a user name… Try this one, it is OK for me 🙂 psql -U username -d myDataBase -a -f myInsertFile If the database is remote, use the same command with host psql -h host -U username -d myDataBase -a -f … Read more
There is a shortcut for SELECT * FROM in standard SQL, so you can use it in psql: TABLE tablename; This syntax shorthand can only be used with a limited range of clauses. The manual: It can be used as a top-level command or as a space-saving syntax variant in parts of complex queries. Only … Read more
Keep reading, the best options come last. But let’s clarify a couple of things first. Only silence the password request If your issue is only the password prompt, you can silence it. I quote the manual here: -w –no-password Never issue a password prompt. If the server requires password authentication and a password is not … Read more
Postgres variables are created through the \set command, for example … \set myvariable value … and can then be substituted, for example, as … SELECT * FROM :myvariable.table1; … or … SELECT * FROM table1 WHERE :myvariable IS NULL; edit: As of psql 9.1, variables can be expanded in quotes as in: \set myvariable value … Read more