Search Postgresql Archives

Re: Updated: Compiling/Installing as a non-admin user

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Before using the createdb binary, su the Linux console as the same user which you used while doing the initdb process on your $PGDATA folder.

Thanks,
--------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 11/1/06, Ritesh Nadhani <riteshn@xxxxxxxxx> wrote:
Hello All

Thanks for all the suggestions. I was able to configire and compile it.
I set the data directory to one of my directories, use 'initdb'
successfully. I am also able to start the pgsql and can see that it is
running on port 4444 as I had configured.

Now the problem is when I try to create a db using createdb, I get the
error:

createdb: could not connect to database postgres: FATAL:  role "ritesh"
does not exist

I am not sure what is that?

Doing a google gave me:
http://pgfoundry.org/pipermail/pgcluster-general/2006-May/000699.html

> You must be postgres user to run this. Another option might be
passing > a user switch .

I cannot run with postgres as I dont have access and I am not sure how
to use the user switch? Any help?

I guess once I am through with this, I am successful!

Ritesh

Richard Huxton wrote:
> Gurjeet Singh wrote:
>> You are talking about /usr/local/data; so I assume that you are trying
>> this
>> on Linux or some other Nixen.
>>
>> You just need to use the --prefix option to configure... Here's what I
>> typically do:
>>
>> Download/'CVS checkout' the sources. Enter the source directory, and
>> invoke
>> configure like this:
>>
>> ./configure --enable-debug --prefix `pwd`/db CFLAGS=-O0
>>
>> And the run 'make' and 'make install'. This will install the data in your
>> <sources_dir>/db/data.
>
> And then of course you'll need to remember to set your port to something
> other than 5432, and tweak your PATH, PGPORT etc or define some
> aliases/wrappers so you don't end up running against the default
> installation. Oh, and you'll need to tweak the startup scripts and
> logging configuration so you get logs somewhere useful.
>
> I think Tom Lane has a script that lets him switch between different
> installations (versions in his case). I only tend to have two versions
> active at any one time, so I just define an alias for psql.
>   alias psql82='/usr/local/pgsql82/bin/psql -p 5434'
> On the rare occasion when I run an 8.2 createdb I need to remember to
> put the port number in manually of course.
>
> HTH

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux