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 doesn
There is a CLI option --serviceaccount 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 the reas
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.
What
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 Post
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 Services:/var/root:/
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 which a user can
use to make any user the owner of postgres service and data files.
Al
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
edbs-Mac
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 Window
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 own
On Fri, Apr 2, 2010 at 5:55 AM, John Gage 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 reason: "The data is inva
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 (b)
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 fil
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:
--service
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 do
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 out
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 pro
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 incre
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 cores
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
d
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 t
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 an
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 e
On Sun, Mar 28, 2010 at 8:20 PM, Yar Tykhiy 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 multiple times (I
On 02/04/2010, Leif Biberg Kristensen 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, a query s
26 matches
Mail list logo
