Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #804 > unrolled thread
| Started by | Peter Percival <peterxpercival@hotmail.com> |
|---|---|
| First post | 2018-02-03 15:56 +0000 |
| Last post | 2018-02-05 19:33 +0000 |
| Articles | 3 — 2 participants |
Back to article view | Back to comp.databases.postgresql
Password? Peter Percival <peterxpercival@hotmail.com> - 2018-02-03 15:56 +0000
Re: Password? Peter Percival <peterxpercival@hotmail.com> - 2018-02-03 20:15 +0000
Re: Password? Laurenz Albe <laurenz@nospam.pn> - 2018-02-05 19:33 +0000
| From | Peter Percival <peterxpercival@hotmail.com> |
|---|---|
| Date | 2018-02-03 15:56 +0000 |
| Subject | Password? |
| Message-ID | <p54m41$uh5$1@news.albasani.net> |
When I installed PostgreSQL it asked me to supply a password, which I did. My first use of the product was to issue this command: createdb books I was asked for a password and I duly typed the one I supplied. It was rejected. Any thoughts?
[toc] | [next] | [standalone]
| From | Peter Percival <peterxpercival@hotmail.com> |
|---|---|
| Date | 2018-02-03 20:15 +0000 |
| Message-ID | <p55596$os0$1@news.albasani.net> |
| In reply to | #804 |
Peter Percival wrote: > When I installed PostgreSQL it asked me to supply a password, which I > did. My first use of the product was to issue this command: > > createdb books > > I was asked for a password and I duly typed the one I supplied. It was > rejected. Any thoughts? It maybe that I need to find .pgpass. If so, where is it?
[toc] | [prev] | [next] | [standalone]
| From | Laurenz Albe <laurenz@nospam.pn> |
|---|---|
| Date | 2018-02-05 19:33 +0000 |
| Message-ID | <p5abip$up1$1@dont-email.me> |
| In reply to | #805 |
Peter Percival wrote: >> When I installed PostgreSQL it asked me to supply a password, which I >> did. My first use of the product was to issue this command: >> >> createdb books >> >> I was asked for a password and I duly typed the one I supplied. It was >> rejected. Any thoughts? > > It maybe that I need to find .pgpass. If so, where is it? .pgpass is in your home directory. I guess from your user agent that you are on Windows. Was the password you entered for an operating system user or for a database user? There is a simple way to get out of this situation: Edit pg_hba.conf and change the authentication method to "trust" for all local and localhost lines. Then restart PostgreSQL. After that, neither "createdb" nor "psql" will ask a password if you are on the same machine, and you can use the psql command "\password" to change your password.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.postgresql
csiph-web