Re: [GENERAL] role does not exist
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? > > -- > Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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). -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Angelico Sent: Thursday, November 01, 2012 9: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 options: 1) Copy and paste from your SSH session locally 2) Transfer the file processes.txt to your local computer, then open it in an editor locally. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Where is 'createdb'?
I watched while the OS was installed and it looked like postgres was installed but the Ubuntu package apparently didnt install it all or it didnt install it correctly. From: Steve Crawford [mailto:scrawf...@pinpointresearch.com] Sent: Thursday, November 01, 2012 4:43 PM To: Boszormenyi 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 current command? The instructions start with "Once you have Postgres installed...". Since the command is not available, you don't have Postgres installed. This is not correct. What it means is that the command you typed is not in your search path or aliased in some way. The command may very well be available elsewhere (see my earlier post in the thread for an example of where Ubuntu places things). $ which createdb /usr/bin/createdb $ rpm -q --whatprovides /usr/bin/createdb postgresql-9.1.6-1.fc17.x86_64 Useful on rpm-based distros but I believe the OP is running a Debian-derivative which uses apt. Cheers, Steve
Re: [GENERAL] role does not exist
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/postgres-xc/datanode2 There are a number of 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 exist On 11/01/2012 06:45 AM, Kevin Burton wrote: > 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 So Postgres is not actually running. What you are seeing is the grep command. If it where running you would see something like: 29041 ? S0:01 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf Try: sudo /etc/init.d/postgresql-9.1 start This should start Postgres. Then do: sudo -u postgres 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/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. > > >> >> -- >> Adrian Klaver >> adrian.kla...@gmail.com >> >> > > -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
If I use vi as my editor how do I copy the text to the clipboard? -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Angelico Sent: Thursday, November 01, 2012 8:57 AM To: pgsql-general@postgresql.org Subject: Re: [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| grep postgresql >processes.txt Then open processes.txt in an editor. You may be able to use the clipboard more easily that way. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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] role does not exist 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
Re: [GENERAL] Where is 'createdb'?
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 'createdb'? On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton wrote: 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'. The text before this command says, "Once you have Postgres installed, create a schema called book using the following command: $ createdb book' But when I tried to issue this command (at a Linux command prompt) I get 'createdb command not found'. Are the authors out of date? What is the current command? The authors are incorrect, in that this doesn't actually create a schema. It creates a database. but they are not out of tdate, just incorrect - it has never created a schema. That said, the createdb command ships with postgresql still and should be avaiable. Exactly where it is depends on how you installed PostgreSQL, and which distribution of Linux you are on. You can probably find it with "find", or by looking at the contents of whichever package you used to install it. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
[GENERAL] Where is 'createdb'?
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'. The text before this command says, "Once you have Postgres installed, create a schema called book using the following command: $ createdb book' But when I tried to issue this command (at a Linux command prompt) I get 'createdb command not found'. Are the authors out of date? What is the current command? Kevin
Re: [GENERAL] role does not exist
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@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 'xc' I choose the common and rebooted. Then I > tried to run psql and I was met with an error that at least one of > postgresql-client- had to be installed so I installed > postgresql-client-9.1. Now when I run psql I get the error: > > psql: could not connect to server: not such file or directory . . . . > > Now what? You have the client side installed but not the server side. You need to install the postgresql package. I have to run, will be away from computer for awhile. Good luck. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
I also tried 'initdb' and I get an error 'The program "initdb" is currently not installed. You can install it by typing: sudo apt-get install postgres-xc'. I didn't do anything since that led to the earlier problem. -Original Message- From: 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: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 in an editor. You may be able to use the > clipboard more easily that way. And per the other posts, change postgresql to postgres for more useful results. But you already knew that. :) ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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 with an error that at least one of postgresql-client- had to be installed so I installed postgresql-client-9.1. Now when I run psql I get the error: psql: could not connect to server: not such file or directory . . . . Now what? -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Thursday, November 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.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? > > Not sure how you are doing the installs/removals. If you are using GUI interface i.e Synaptic then search for postgres-xc and then follow removal procedure. If from the command line: To get the name of the packages: dpkg -l|grep postgres-xc Then sudo apt-get purge whatever_package_name -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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? -Original Message- From: 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. 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 postgres-xc is > clustering software I just did what I was told. If that is my mistake > then how do I uninstall it? Or is it easier to install the OS again? You should not have to reinstall the OS that is a Windows thing. A fuller explanation of how you got to this point would be helpful though. What version of Ubuntu are you on? What Postgres did you initially install? Did you install any other packages when you encountered the error, other than Postgres-XC? FYI as far as I know when you use the Ubuntu(Debian) package it runs initdb as part of the install and you should not have to. -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Angelico Sent: Thursday, November 01, 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. For example, I use webmail with a GUI web browser, so the editor that I'd use to copy to the clipboard would be one running in the same X session (or, when I happen to be on Windows, on the same Windows computer). Alternatively, you may be able to directly import from a file into an email. Again, you'd have to know your mailer. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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 postgres-xc is clustering software I just did 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'; pgsql-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/postgres-xc/datanode1 > 1233 ? S 0:01 /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode2 > > There are a number of entries of the form: > > 1185 ? Ss 0:10 postgres: pooler process > That is not what you said you installed. It is Postgres-XC, a clustering software. Not only that there is pooling software between you and the database. Are you working with different machines? -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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: 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) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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 Subject: 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 in a terminal then use the mouse to select the area and then right click and select copy. > > > -- > Adrian Klaver > adrian.kla...@gmail.com > > > -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of 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 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, 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. > > -- > Adrian Klaver > adrian.kla...@gmail.com > > -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 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, 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. > > -- > Adrian Klaver > adrian.kla...@gmail.com > > -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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 I still get ' psql: FATAL: role "postgres" does not exist' when I execute '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: [GENERAL] role does not exist 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 seem to be getting farther and farther > from the original question, that of role "postgres" does not exist. > I just tested an install of Postgres on Ubuntu and sudo -u postgres psql worked just fine. Are you sure you installed all of the Postgres packages? What does dpkg -l| grep postgresql show? Is Postgres is running? What does ps ax| grep postgresql show? > -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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 seem to be getting 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 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" 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.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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.org 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 Ubuntu packages, there's documentation on post-install setup steps in /usr/share/doc/[packagename]/README.Debian.gz. See: zless /usr/share/doc/postgresql-?.?/README.Debian.gz -- Craig Ringer
Re: [GENERAL] role does not exist
What am I looking for? It is full of comments. If I am looking at the lines that don't begin with '#' I only see all and postgres as users. -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 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" 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.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] role does not exist
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: Kevin 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 > "" 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 me step by step directions on how to import > the databases from SQL Server. Actually I only want a few tables in > the database. Hints? Well step by step is a bit exhaustive for a mailing list. To solve the specific question the default user is postgres and the default super user within postgresql is postgres. Try this: sudo -u postgres psql JD > > Thank you. > -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC @cmdpromptinc - 509-416-6579 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] role does not exist
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 me step by step directions on how to import the databases from SQL Server. Actually I only want a few tables in the database. Hints? Thank you.
