The 8.4.2 documentation says:
The default user name is your Unix user name, as is the default
database name.
Not so much. My one-click installer creates a user 'postgres' who
becomes the default user name...as well as the owner of the data file.
Is postgres arguing with itself here? Or
John Gage wrote:
The 8.4.2 documentation says:
The default user name is your Unix user name, as is the default
database name.
when you as a user connect to the database server the commands like
psql, pg_dump, etc all use your unix username as the default for the
database username, and your
Then I don't understand why the installer doesn't do the same thing.
Or, in the alternative, why it doesn't ask you what you want these
parameters to be.
I would say that, typically, someone installing postgres does it,
conceivably, as root or, more likely, as a user.
What he or she
There is a CLI option --serviceaccount username which a user can use
to make any user the owner of postgres service and data files.
Also, if you choose 'postgres' as the service account and the 'postgres'
user doesn't exist. The installer will create postgres as a 'locked'
user account. Thats
John Gage wrote:
Then I don't understand why the installer doesn't do the same thing.
Or, in the alternative, why it doesn't ask you what you want these
parameters to be.
I would say that, typically, someone installing postgres does it,
conceivably, as root or, more likely, as a user.
I lied. The Unix id command produces:
JohnGage:~ johngage$ id postgres
uid=502(postgres) gid=1(daemon) groups=1(daemon)
The one-click installer should be very clear about all this.
I think we are very close to Steve Jobs Chain of Pain here.
And, once again, I am absolutely dedicated to
If I do cat /etc/passwd, I get the following, which does not include
'postgres'. Yet id knows about 'postgres'. And 'postgres' owns the
data.
nobody:*:-2:-2:Unprivileged User:/var/empty:/usr/bin/false
root:*:0:0:System Administrator:/var/root:/bin/sh
daemon:*:1:1:System
There is a CLI option where? Forgive my ignorance, please. Does it
appear in the one-click installer?
John
On Apr 2, 2010, at 9:19 AM, Sachin Srivastava wrote:
There is a CLI option --serviceaccount username which a user can
use to make any user the owner of postgres service and data
Thats what i get:
edbs-MacBook:~ sachin$ hdiutil attach postgresql-8.4.3-1-osx.dmg
expected CRC32 $F9B026D4
/dev/disk1 Apple_partition_scheme
/dev/disk1s1Apple_partition_map
/dev/disk1s2Apple_HFS
/Volumes/PostgreSQL 8.4.3-1
On 2/04/2010 3:07 PM, John Gage wrote:
Yet, that is what the one-click installer does. I do not believe that
this is intuitive. What is more, gratuitiously adding a user to the
system doesn't seem to make a whole lot of sense.
This is absolutely standard practice on UNIX systems, and on
On 2/04/2010 3:42 PM, John Gage wrote:
If I do cat /etc/passwd, I get the following, which does not include
'postgres'. Yet id knows about 'postgres'. And 'postgres' owns the data.
Try:
sudo dscl localhost -list NetInfo/Users
Apple don't use the usual UNIX utilities, they've got their
On Fri, Apr 2, 2010 at 5:55 AM, John Gage jsmg...@numericable.fr wrote:
I will bet a bucket of day-old squid that this is a user rights problem.
They usually are, so I'm not taking that bet. We do see one regular
issue where Microsoft's cacl's command gives an unhelpful error for no
apparent
On Apr 2, 2010, at 10:28 AM, Craig Ringer wrote:
b) Run as your user. What if you remove the user later - crunch,
your database just broke. If Pg was attacked successfully, the
attacker wouldn't get root ... but they would get the ability to
access and delete all your files.
Arguably
I'm not quite as brain-dead as this statement makes me sound. I use
posgres' back-up system to back up the databases. I don't copy the
files.
On Apr 2, 2010, at 12:15 PM, John Gage wrote:
And the only reason I know that 'postgres' owns my data (or did) is
that I wanted to back up the
I am incredibly interested in this.
In the first place, I did not load postgres from the command line as
you do here. I double-clicked. I also do not remember seeing the
usage options.
That being said, now that I have downloaded and installed the system,
how can I change:
Yes you need to re-install.. (uninstall and install again).
You can point the new installation to the old data directory if you want..
On 4/2/10 4:25 PM, John Gage wrote:
I am incredibly interested in this.
In the first place, I did not load postgres from the command line as
you do here. I
I need to make certain views from the database visible online (on our
webpage) and I wonder if there is any reasonably quick solution for this
that works with Postgres?
At best, a query should be specified and the user should be able to select
the layout on certain columns (like stepped, or
See attached attached OneClick_PG_Installer notes.
Igor Neyman
-Original Message-
From: John Gage [mailto:jsmg...@numericable.fr]
Sent: Friday, April 02, 2010 3:44 AM
To: sachin.srivast...@enterprisedb.com
Cc: pgsql-general@postgresql.org
Subject: Re: 1-Click installer problems
Thanks very, very much for this. I am truly grateful.
On Apr 2, 2010, at 2:44 PM, Sachin Srivastava wrote:
Yes you need to re-install.. (uninstall and install again).
You can point the new installation to the old data directory if you
want..
On 4/2/10 4:25 PM, John Gage wrote:
I am
I'm using apache and postgres to make an ecommerce website work on
an old xeon box
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
It looks it has 4
On Friday 2. April 2010 14.43.48 Davor J. wrote:
I need to make certain views from the database visible online (on our
webpage) and I wonder if there is any reasonably quick solution for this
that works with Postgres?
At best, a query should be specified and the user should be able to
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Is anyone using Lifekeeper for Linux availability with Postgres?
If so, what are your thoughts on it? Work as advertised?
Any dangerous gotchas?
Works well. May need to change the way it kills Postgres though,
IIRC it defaults to a
Hi all -
I have created dump of a database where I have a tablespace
(data_tblspace ) associated with relations. I have restored to a different
server. I created the same table space. Now I need to create an other
database on the same server using the same dump. but I need to have a
On Friday 02 April 2010 12:44, akp geek wrote:
Hi all -
I have created dump of a database where I have a tablespace
(data_tblspace ) associated with relations. I have restored to a different
server. I created the same table space. Now I need to create an other
database on the
I have been using this one liner c function that I call my_now() to
get the number of seconds since some fixed point in the past. I find
it more convenient than built-in now()
and if I want abstime I do abstime(my_now()). Thing is everytime I
do a major version upgrade I had to recompile this
On Friday 02 April 2010 5:41:09 pm zhong ming wu wrote:
I have been using this one liner c function that I call my_now() to
get the number of seconds since some fixed point in the past. I find
it more convenient than built-in now()
and if I want abstime I do abstime(my_now()). Thing is
On Sun, Mar 28, 2010 at 8:20 PM, Yar Tykhiy y...@barnet.com.au wrote:
Guys, I'm afraid there may be some confusion here. I've got a warm
standby happily running with simple home-made archive and restore
scripts on a legacy Postgresql installation as old as 8.0. And yes, I
did failover
On 02/04/2010, Leif Biberg Kristensen l...@solumslekt.org wrote:
On Friday 2. April 2010 14.43.48 Davor J. wrote:
I need to make certain views from the database visible online (on our
webpage) and I wonder if there is any reasonably quick solution for this
that works with Postgres?
At best,
28 matches
Mail list logo