I have successfully installed PostgreSQL on a Ubuntu Linux machine. However
right off the bat I type 'psql' and I get the error: 'role "" does not
exist'. Where xxx is the user name logged in. How do I overcome this hurdle.
Right now all of our data is on a Windows SQL Server. Can someone give
I tried this and I get an error that
'psql: FATAL: role "postgres" does not exist'
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Wednesday, October 31, 2012 6:33 PM
To: Ke
Sent: Wednesday, October 31, 2012 8:42 PM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 10/31/2012 06:01 PM, Kevin Burton wrote:
> I tried this and I get an error that
>
> 'psql: FATAL: role "postgres&q
Sorry there isn't a README.Debian.gz in the postgresql-doc-9.1. There is a
changelog.Debian.gz but that doesn't seem to address this problem.
From: Craig Ringer [mailto:ring...@ringerc.id.au]
Sent: Thursday, November 01, 2012 12:33 AM
To: Kevin Burton
Cc: pgsql-general@postgresql.o
farther and farther from
the original question, that of role "postgres" does not exist.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Wednesday, October 31, 2012 8:42 PM
To: Kevin Burton
C
x27;sudo -u postgres psql'.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Thursday, November 01, 2012 8:24 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re:
I am having a hard time with the clipboard so I will reproduce the output as
best as I can:
2066 tty1 S+ 0:00 grep --color=auto postgresql
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 8:42 AM
To: Kevin Burton
Cc: 'Jos
S+ 0:00 grep --color=auto postgresql
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 8:42 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 11/01/2012 06:38 AM, K
I put the mouse in the command window and I don't see anything getting
selected.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 8:58 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subjec
Yes. This is what I did. It shows a number of entries but I cannot get the
clipboard to work so for now I cannot detail all of the entries.
-Original Message-
From: Kevin Grittner [mailto:kgri...@mail.com]
Sent: Thursday, November 01, 2012 8:51 AM
To: Adrian Klaver; Kevin Burton
Cc
what
I was told. If that is my mistake then how do I uninstall it? Or is it
easier to install the OS again?
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 9:11 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgs
, 2012 9:14 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On Fri, Nov 2, 2012 at 1:06 AM, Kevin Burton
wrote:
> If I use vi as my editor how do I copy the text to the clipboard?
I would recommend picking an editor that matches the way you post to the
list.
om: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 9:34 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 11/01/2012 07:16 AM, Kevin Burton wrote:
> I am not running on multiple machines.
r 01, 2012 9:51 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 11/01/2012 07:38 AM, Kevin Burton wrote:
> The version of Ubuntu is 12.10.
>
> I am not sure what version of PostgreSQL it install but it is now 9
pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Angelico
Sent: Thursday, November 01, 2012 8:58 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On Fri, Nov 2, 2012 at 12:56 AM, Chris Angelico wrote:
> On Fri, Nov 2, 2012 at 12
Sudo -u postgres psql - now works!! Thank you. Now how do I add a role so
that I don't have to use sudo?
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 10:13 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general
This is probably a question for the authors of a book I have been reading
but it may be faster to get an answer here.
I was trying to follow along in a book 'Seven Databases in Seven Weeks' and
chapter 2 deals with PostgreSQL. One of the first things it does is issue a
command 'createdb book'.
I type 'find createdb' and I get an error find: 'createdb' no such file or
directory.
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Thursday, November 01, 2012 10:38 AM
To: Kevin Burton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where is 'crea
Now I get psql: FATAL: role "kevin" is not permitted to log in
-Original Message-
From: Kevin Grittner [mailto:kgri...@mail.com]
Sent: Thursday, November 01, 2012 10:31 AM
To: Kevin Burton; Adrian Klaver
Cc: Joshua D. Drake; pgsql-general@postgresql.org
Subject: Re: [GENERAL]
: [GENERAL] role does not exist
On Fri, Nov 2, 2012 at 12:51 AM, Kevin Burton
wrote:
> If you change the grep to postgres then there are a number of entries
> (about 17). The output since I don't have a clipboard is too much to
> try and type in by hand.
Try this:
ps ax| g
entries of the form:
1185 ? Ss 0:10 postgres: pooler process
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 8:52 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not ex
Zoltan
Cc: Kevin Burton; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where is 'createdb'?
On 11/01/2012 02:10 PM, Boszormenyi Zoltan wrote:
2012-11-01 16:32 keltezéssel, Kevin Burton írta:
...I get createdb command not found. Are the authors out of date? What is
the curre
21 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On Fri, Nov 2, 2012 at 1:18 AM, Kevin Burton
wrote:
> I am not working on the same machine that I read email from. The
> machine that has the Linux Server on it has no GUI installed.
In that case, two option
I was not aware of the login option. That is probably the solution. Thank you.
On Nov 2, 2012, at 10:43 PM, Craig Ringer wrote:
> On 11/01/2012 11:46 PM, Kevin Burton wrote:
>> Now I get psql: FATAL: role "kevin" is not permitted to log in
> Did you perhaps CREATE ROLE wi
24 matches
Mail list logo
