On 11/03/2012 12:17 PM, Kevin Burton wrote:
> I was not aware of the login option. That is probably the solution. Thank you.
You can ALTER the user to add the LOGIN right, or just DROP it and
re-CREATE it again.
CREATE USER is shorthand for CREATE ROLE ... LOGIN
--
Craig Ringer
--
Sent via pgs
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 without the LOGIN option?
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 without the LOGIN option?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
On Fri, Nov 2, 2012 at 10:35 AM, Adrian Klaver wrote:
> On 11/01/2012 03:03 PM, Chris Angelico wrote:
>>
>> My crystal ball tells me that you're SSHing to your remote server,
>> running SSH in some kind of local terminal. It's the local terminal
>> that will offer copy/paste facilities. Without kn
On 11/01/2012 03:03 PM, Chris Angelico wrote:
On Fri, Nov 2, 2012 at 8:56 AM, Kevin Burton wrote:
That is the problem. There doesn't seem to be any copy on the Linux shell
that I am running (I think it is bash).
My crystal ball tells me that you're SSHing to your remote server,
running SSH i
On 11/01/2012 02:56 PM, Kevin Burton wrote:
That is the problem. There doesn't seem to be any copy on the Linux shell
that I am running (I think it is bash).
At a guess you are running the commands from the wrong shell. I asked
before whether you are running from different machines and you sa
On Fri, Nov 2, 2012 at 8:56 AM, Kevin Burton wrote:
>
> That is the problem. There doesn't seem to be any copy on the Linux shell
> that I am running (I think it is bash).
My crystal ball tells me that you're SSHing to your remote server,
running SSH in some kind of local terminal. It's the local
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
On 11/01/2012 07:00 AM, Kevin Burton wrote:
I do see actually three lines with a -D in it that may be similar:
1166 ? S 0:01 /usr/bin/postgres -C -D /var/lib/postgres-xc/coord
1214 ? S 0:01 /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode1
1233 ? S 0:01 /usr/bin/postgres -X -D /var/lib/post
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
: [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
Le jeudi 01 novembre 2012 à 10:21 -0500, Kevin Burton a écrit :
> Sudo -u postgres psql - now works!! Thank you. Now how do I add a role so
> that I don't have to use sudo?
>
http://www.postgresql.org/docs/9.1/static/app-createuser.html
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion
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]
:~$ psql authDBpsql (8.4.11)Type "help" for
help.
authDB=#
> From: rkevinbur...@charter.net
> To: adrian.kla...@gmail.com
> CC: j...@commandprompt.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] role does not exist
> Date: Thu, 1 Nov 2012 10:21:31 -0500
>
&
Kevin Burton wrote:
> how do I add a role [...] ?
http://www.postgresql.org/docs/9.2/interactive/database-roles.html
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 11/01/2012 08:06 AM, Kevin Burton wrote:
> I had to install postgresql-client-common and postgresql-client-9.1 to
> get psql it said that psql was in postgresql-client-common AND
postgresql-xc.
> Now that I know to avoid
On 11/01/2012 08:06 AM, Kevin Burton wrote:
I had to install postgresql-client-common and postgresql-client-9.1 to get
psql it said that psql was in postgresql-client-common AND postgresql-xc.
Now that I know to avoid 'xc' I choose the common and rebooted. Then I tried
to run psql and I was met w
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
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
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.1
No other packages were installed (I installed 'make' to try and see the
documentation).
So how do I uninstall postgreSQL-XC if that is the problem?
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.
On 11/01/2012 07:16 AM, Kevin Burton wrote:
I am not running on multiple machines. I think that initdb or something like
it was not installed so it when I tried to invoke it Iwas met with an error
that initdb is in the postgres-xc package and then told me how to install
it. Not having known that
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 options:
1) Copy and paste from your SSH session locally
2) Transfer the file processes.txt to
, 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.
ql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 11/01/2012 07:00 AM, Kevin Burton wrote:
> I do see actually three lines with a -D in it that may be similar:
>
> 1166 ? S 0:01 /usr/bin/postgres -C -D /var/lib/postgres-xc/coord
> 1214 ? S 0:01 /usr/bin/postgres -X -D /var/lib
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. For example, I use webmail with a GUI web browser, so the
editor that I'd use to copy to the clipb
: Joshua D. Drake; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
Adrian Klaver wrote:
> What does ps ax| grep postgresql show?
Are you sure you don't want this?:
ps ax | grep postgres
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
t: Re: [GENERAL] role does not exist
On 11/01/2012 06: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.
>
If you are seeing the above
On 11/01/2012 06: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.
If you are seeing the above in a terminal then use the mouse to select
the area and t
On Fri, Nov 2, 2012 at 12:56 AM, Chris Angelico wrote:
> 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 thi
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| grep postgresql >processes.txt
Then open processes.txt
Adrian Klaver wrote:
> What does ps ax| grep postgresql show?
Are you sure you don't want this?:
ps ax | grep postgres
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ostgres psql
>
>
> -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/
Kevin Burton
Sent: Thursday, November 01, 2012 8:45 AM
To: 'Adrian Klaver'
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
I am having a hard time with the clipboard so I will reproduce the output as
best as I can:
2066 tty1
hua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 11/01/2012 06:38 AM, Kevin Burton wrote:
> Dpkg -l | grep postgresql shows
> postgresql-9.1
> postgresql-common
> postgresql-client-common
> postgresql-doc
> postgr
On 11/01/2012 06:38 AM, Kevin Burton wrote:
Dpkg -l | grep postgresql shows
postgresql-9.1
postgresql-common
postgresql-client-common
postgresql-doc
postgresql-doc-9.1
Ps -ax | grep postgresql shows
Postgresql
Please show the actual output from the ps command.
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:
On 11/01/2012 05:02 AM, Kevin Burton wrote:
There is a tutorial directory but it has a README that I need to type 'make'
to view the files. Well, make wasn't available so I installed 'make' with
apt-get. Then I was met with an error apparently from the Makefile that
pg_conf: command not found. I
c: '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" does not exist'
What is the content of /et
rg
Subject: Re: [GENERAL] role does not exist
On 11/01/2012 06:54 AM, Kevin Burton wrote:
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'.
As with most U
On 11/01/2012 06:54 AM, Kevin Burton wrote:
>
> 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'.
>
As with most Ubuntu packages, there's documentation on post-install
setup steps in /u
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
On 10/31/2012 06:01 PM, Kevin Burton wrote:
I tried this and I get an error that
'psql: FATAL: role "postgres" does not exist'
What is the content of /etc/postgresql/pg_hba.conf?
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
vin Burton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not exist
On 10/31/2012 03:54 PM, Kevin Burton wrote:
> I have successfully installed PostgreSQL on a Ubuntu Linux machine.
> However right off the bat I type 'psql' and I get the error: 'role
> &
On 10/31/2012 03:54 PM, Kevin Burton wrote:
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 dat
On 10/31/2012 03:54 PM, Kevin Burton wrote:
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
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
47 matches
Mail list logo
