On 03/11/2010 11:43, Gabriele Bulfon wrote:
Thanx guys, all of your solutions are fine, but I could manage it in a
different manner.
Modified the ident map file to map my special system user to postgres,
so I don't have to
specify the postgres user any more ;)
Good stuff! Glad you got it to wor
bTop2 =-
--
Da: Gabriele Bartolini
A: Gabriele Bartolini
Cc: Gabriele Bulfon
pgsql-general@postgresql.org
Data: 3 novembre 2010 12.26.04 CET
Oggetto: Re: [GENERAL] Running postgres with a different user/group
Hi Gabriele,
I forgot to mention one thing.
Hi Gabriele,
I forgot to mention one thing.
> That means that PostgreSQL is successfully running. Try and connect to
the
> database using a different user by passing the '-U' option to psql or by
> setting the PGUSER environment variable.
PostgreSQL creates a role/user inside the cluster with
Hi Gabriele,
On Wed, 3 Nov 2010 11:29:25 +0100 (CET), Gabriele Bulfon
wrote:
> I need to run postgres under the same user/group, witout having to
create
> and use postgres user.
That's reasonable and perfectly doable with Postgres.
> But now I can't seem to connect to the database, because it s
On 03/11/2010 10:29, Gabriele Bulfon wrote:
Hi,
I installed latest postgres from sources inside a custom environment of
mine.
This environment runs various services, all under a common user/group.
I need to run postgres under the same user/group, witout having to
create and use postgres user.
I c
Hi,
I installed latest postgres from sources inside a custom environment of mine.
This environment runs various services, all under a common user/group.
I need to run postgres under the same user/group, witout having to create and
use postgres user.
I could do it, and postgres starts.
But now I ca
On Thu, Feb 05, 2009 at 12:05:31PM +0530, Kusuma Pabba wrote:
> how can i create a user in test or template
> when i give create user
> it is asking for create role , how should i create role?
Users are associated with the "cluster" and not with any specific
database. I tend to add users by dire
On Thu, Feb 05, 2009 at 08:12:48AM +, Sebastian Tennant wrote:
> This is why you need to type 'sudo su postgres -c psql template1'.
A little shortcut, you can do the above from sudo as:
sudo -u postgres psql template1
This was pointed out to me by another kind soul on this list, but I
can'
Quoth Kusuma Pabba :
> /usr/local/pgsql/bin/psql test
> test=#
> sudo su postgres -c psql template1
> template=#
> why is the path different in both cases?
Type:
$ which psql
and
$ sudo which psql
The answer is the same, yes?
$ /usr/local/pgsql/bin/psql test
|___|
On Thu, Feb 5, 2009 at 15:35, Kusuma Pabba wrote:
>
> may this be a silly doubts but , i am new to postgres, please answer to
> these::
>
> /usr/local/pgsql/bin/psql test
> test=#
>
>
> sudo su postgres -c psql template1
> template=#
>
>
> what is the difference between the above two and,
> why is
may this be a silly doubts but , i am new to postgres, please answer to
these::
/usr/local/pgsql/bin/psql test
test=#
sudo su postgres -c psql template1
template=#
what is the difference between the above two and,
why is the path different in both cases
which should i use now
how can i c
On Thu, Oct 18, 2007 at 10:50:02AM -0500,
Scott Marlowe <[EMAIL PROTECTED]> wrote
a message of 18 lines which said:
> Personally, I found it quite easy.
>
> apt-get install postgresqlp8.2
> sudo /etc/init.d/postgres-8.2 start
> sudo su - postgres
> psql
>
> 4 whole steps.
Although I regard
Em Thursday 18 October 2007 14:57:27 brian escreveu:
> Ken Johansson wrote:
> > Hello,
> >
> > Sorry everyone for the stupid rant. Wont happen again. And thanks for
> > offer assistance. I seem to have it running and once i have a valid
> > question ill post it.
> >
> > Sorry again..
> >
> > Ken
Scott Marlowe wrote:
On 10/18/07, Ken Johansson <[EMAIL PROTECTED]> wrote:
and i though PostgreSQL would be easier to get up and running than SQL
server
I sincerely hope you don't consider that the sole criteria for
choosing databases.
I don't know - it's put me off MS-SQL in a b
Ken Johansson wrote:
Hello,
Sorry everyone for the stupid rant. Wont happen again. And thanks for
offer assistance. I seem to have it running and once i have a valid
question ill post it.
Sorry again..
Ken
We'll put it down as "thinking out loud" then. It happens. ;-)
brian
---
On 10/18/07, Ken Johansson <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Sorry everyone for the stupid rant. Wont happen again. And thanks for
> offer assistance. I seem to have it running and once i have a valid
> question ill post it.
Don't worry about it. We've all had to cut our teeth sometime.
Hello,
Sorry everyone for the stupid rant. Wont happen again. And thanks for
offer assistance. I seem to have it running and once i have a valid
question ill post it.
Sorry again..
Ken
On 18/10/2007, brian <[EMAIL PROTECTED]> wrote:
>
> Ken Johansson wrote:
> > and i though PostgreSQL would
On 10/18/07, Ken Johansson <[EMAIL PROTECTED]> wrote:
> and i though PostgreSQL would be easier to get up and running than SQL
> server
I sincerely hope you don't consider that the sole criteria for
choosing databases.
Personally, I found it quite easy.
apt-get install postgresqlp8.2
Ken Johansson wrote:
and i though PostgreSQL would be easier to get up and running than SQL
server
Question? Complaint? Thinking out loud? Lyrics to a song? We're all
standing by, Ken!
---(end of broadcast)---
TIP 3: Have you check
and i though PostgreSQL would be easier to get up and running than SQL
server
--
Ken
On 8/6/06, jesus martinez <[EMAIL PROTECTED]> wrote:
Merlin, first all, thanks for taking time to
answer me.
- where do i have to find the tutorial you
said ? do you have the URL ?
http://pginstaller.projects.postgresql.org/silent.html
- i actually didnt try the silent-mode.
because the re
On 8/6/06, jesus martinez <[EMAIL PROTECTED]> wrote:
hello, how are you ?
i want to distribute a copy of PostGres to my clients.
they really dont know anything about installing
programs or
configurating remote RDBMS sql-servers,
so i dont want to give them the
"official-PostGres-installer.exe"
b
hello, how are you ?
i want to distribute a copy of PostGres to my clients.
they really dont know anything about installing
programs or
configurating remote RDBMS sql-servers,
so i dont want to give them the
"official-PostGres-installer.exe"
but my own installer.exe (win32) that:
1) install the P
23 matches
Mail list logo
