On Jan 30, 2006, at 7:52 PM, Joshua D. Drake wrote:
There is a reason that even Oracle has a graphical installer on
Linux, because most people installing
the software:
A. Don't know how to use it
B. Probably don't know how to use Linux
C. Don't want to.
Except that the Oracle "graphical ins
Rick Gigger schrieb:
I don't see why anyone has a problem with this. I am certainly never
going to use it but if it helps someone who isn't a linux person to use
it on a project when they would have used something else (like mysql)
or if it convinces someone to run postgres on linux instead
On Tue, 31 Jan 2006, Tino Wildenhain wrote:
Devrim GUNDUZ schrieb:
Hi,
...
Are you going to work with the underlying system's package manager, or
put everything in /usr/local?
We'll work with the package manager -- I'm an RPM guy ;)
RPM isnt the only packaging system out there ;)
I th
Joshua D. Drake schrieb:
...
As more and more people come on board people are going to want to
download a .exe (a metaphor),
double click and have it open an installer, they will then want to click
next, next, continue, finish.
You don't get that with apt-get install.
Well you can use a fron
Jonah H. Harris schrieb:
I had to deal with an installer written in python and several in Java...
IMHO, Java would be a better language for this and you could build off
some nice OSS installers that already exist (such as IzPack). Just my 2
cents :)
Yes! Use Java for ultimate suckiness of th
Devrim GUNDUZ schrieb:
Hi,
...
Are you going to work with the underlying system's package manager, or
put everything in /usr/local?
We'll work with the package manager -- I'm an RPM guy ;)
RPM isnt the only packaging system out there ;)
---(end of broadcast)--
Devrim GUNDUZ schrieb:
Hi,
As you know, many databases that run on Linux / Unix systems have a GUI
installer which make installation easier and more attractive for some
people.
If you think of the *racle-GUI-Installer, most people find it very
s*cking ;)
Our Windows Installer is very attracti
On Jan 30, 2006, at 8:48 PM, Tony Caduto wrote:
Devrim GUNDUZ wrote:
Have you looked at AutoPackage?
http://autopackage.org
screen shots.
http://autopackage.org/gallery.html
Has a GUI wizard if X windows is available and a command line
wizard if no X is available.
Using autopackage is
Jeff,
So why don't you just do that with Postgres? You could call it
"Bootable PostgreSQL". It would be a big hit. When a new version comes
out, you can just mail out a new DVD.
Actually, we have these. We give them out at conferences.
--Josh
---(end of broadcast)
On Mon, 2006-01-30 at 20:53 -0800, Joshua D. Drake wrote:
> > Oracle's graphical installer is a material impediment to Oracle
> > adoption. The installer only works on systems where particular versions
> > of Java and Motif libraries are available. On 64-bit Opteron systems it
> > only works with
Oracle's graphical installer is a material impediment to Oracle
adoption. The installer only works on systems where particular versions
of Java and Motif libraries are available. On 64-bit Opteron systems it
only works with the peculiar 32-bit thunking tree favored by Red Hat and
hardly anybod
Devrim GUNDUZ wrote:
Have you looked at AutoPackage?
http://autopackage.org
screen shots.
http://autopackage.org/gallery.html
Has a GUI wizard if X windows is available and a command line wizard if
no X is available.
Using autopackage is similar to using MSI,Wise,Inno etc on Windows.
Lat
On Mon, 2006-01-30 at 19:52 -0800, Joshua D. Drake wrote:
> >
> >
> >On my Debian systems, I can install PostgreSQL quite readily via the
> >command "apt-get install postgresql-8.1", which can get GUIed at least
> >somewhat if I run aptitude, synaptic, or such...
> >
> >
> Yes Christopher, you ca
I don't see why anyone has a problem with this. I am certainly never
going to use it but if it helps someone who isn't a linux person to
use it on a project when they would have used something else (like
mysql) or if it convinces someone to run postgres on linux instead of
windows because
On Mon, 30 Jan 2006, Joshua D. Drake wrote:
On my Debian systems, I can install PostgreSQL quite readily via the
command "apt-get install postgresql-8.1", which can get GUIed at least
somewhat if I run aptitude, synaptic, or such...
Yes Christopher, you can... I can, and Devrim can
As m
On my Debian systems, I can install PostgreSQL quite readily via the
command "apt-get install postgresql-8.1", which can get GUIed at least
somewhat if I run aptitude, synaptic, or such...
Yes Christopher, you can... I can, and Devrim can
As more and more people come on board people are
Marc G. Fournier wrote:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do you?
On Jan 30, 2006, at 8:32 PM, Devrim GUNDUZ wrote:
However none of them are PostgreSQL Installers, none of them has the
ability to customize the packages and none of them has the ability to
install the community packages, etc. :)
You need to take a sniff over at the FreeBSD ports. Lets you b
> We are actively looking for developers for the project. Please drop me
> an e-mail if you want to join this project. We will use Python, so you
> need to be a Python guy to join the project. We are in planning phase,
> if you join us earlier, we will be able to share more ideas.
You'd better de
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
>
>> On my RHEL boxes, I do never ever recompile the kernel since Red Hat
>> does not provide support if I do so :)
>
> Is everything 'loadable modules' then? I can't imagine you have some
> mammoth kernel
I had to deal with an installer written in python and several in Java... IMHO, Java would be a better language for this and you could build off some nice OSS installers that already exist (such as IzPack). Just my 2 cents :)
On 1/30/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Hi,On Mon, 2006-01-3
Marc G. Fournier wrote:
More seriously, I know under FreeBSD, one of the first things that
gets done after installing is to customize the kernel to get rid of
all the 'cruft' part of the generic kernel, I take it that this isn't
something that ppl do with Linux?
The Linux kernel has lo
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do you? with every conceivable
p
Hi,
On Mon, 2006-01-30 at 22:04 -0400, Marc G. Fournier wrote:
>> BTW, gcc is not installed on by default AFAIR.
>
> Wow, how do you update the kernel each week? :)
>
> More seriously, I know under FreeBSD, one of the first things that gets
> done after installing is to customize the kernel to
On Mon, 30 Jan 2006, Robert Treat wrote:
On Monday 30 January 2006 16:21, Marc G. Fournier wrote:
On Mon, 30 Jan 2006, Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
Mark Woodward wrote:
There should e a big huge button and/or link
to pgfountr
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get rid of all the
'cruft' par
On Monday 30 January 2006 16:21, Marc G. Fournier wrote:
> On Mon, 30 Jan 2006, Robert Treat wrote:
> > On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
> >> Mark Kirkwood said:
> >>> Mark Woodward wrote:
> There should e a big huge button and/or link
> to pgfountry that shows how m
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
> > You can install, but what if you need different configure options than
> > the package provides? This means a rebuild of the package. Instead, we
> > will build and install that package via the installer.
>
> That's actually a pretty
Hi,
On Mon, 2006-01-30 at 21:34 -0400, Marc G. Fournier wrote:
> > OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
> > RPM interface for the repositories. So our installer will help them a
> > lot. Also, our installer will have an option to download and install the
> > preb
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
>
> Certainly you can install pre-built binaries without a compiler, and
> let the user choose database location, autovacuum settings and stuff
> like that.
That's another good point. We can adjust many settings before
installing.
Reg
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
Hi,
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We a
Hi,
On Mon, 2006-01-30 at 20:27 -0500, Andrew Dunstan wrote:
> >OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
> >RPM interface for the repositories. So our installer will help them a
> >lot. Also, our installer will have an option to download and install the
> >prebuilt
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
>
>> What value does this bring to systems that have a good package system
>> and up-to-date repositories? I can install Postgres today on Ubuntu
>> using a GUI tool, and install another GUI tool t
Devrim GUNDUZ wrote:
OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt binaries from PostgreSQL FTP site (and possible o
Hi,
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
> > We are actively looking for developers for the project. Please drop me
> > an e-mail if you want to join this project. We will use Python, so you
> > need to be a Python guy to join the project. We are in planning phase,
> > if you j
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> http://pgfoundry.org/projects/pgnixinstaller/
>
> We are actively looking for developers for the project. Please drop me
> an e-mail if you want to join this project. We will use Python, so you
> need to be a Python guy to join the project. We are in pla
Hi,
As you know, many databases that run on Linux / Unix systems have a GUI
installer which make installation easier and more attractive for some
people.
Our Windows Installer is very attractive, for example.
Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a
new project: p
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Joachim Wieland wrote:
>> I wonder if there is a policy on when schema-qualified names should
>> be used in ereport/elog messages.
> If it's not too hard to do, I would add the schema name in most places.
Actually, it's semi-consciously omitted in mo
Secondly, if there is a "large group of users" who want this, why
doesn't someone do it? Any one of them could take the source, and
produce a bundle (say a PostgresPHP Plus Pack) that has all the
features you think should be in there. If they can demonstrate they can
maintain it, perhaps the pos
Joachim Wieland wrote:
> I wonder if there is a policy on when schema-qualified names should
> be used in ereport/elog messages.
If it's not too hard to do, I would add the schema name in most places.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end o
On Mon, Jan 30, 2006 at 04:35:15PM -0500, Mark Woodward wrote:
> It gets so frustrating sometimes, it isn't so black and white, there are
> many levels of gray. The PostgreSQL project is trying so hard to be
> neutral, that it is making itself irrelevant.
>
> Designing and including features that
David Fetter wrote:
> On Thu, Jan 26, 2006 at 10:17:05PM -0500, Tom Lane wrote:
> > David Fetter <[EMAIL PROTECTED]> writes:
> > > I have seed database scripts quasi-generated from pg_dump which
> > > include COPY statements, but the data is hard to edit (especially
> > > cut & paste operations) wh
On Mon, 30 Jan 2006, Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
Mark Woodward wrote:
There should e a big huge button and/or link
to pgfountry that shows how much is availale to PostgreSQL.
While there are links to 'em mentioned on the web
On Mon, 30 Jan 2006, Mark Woodward wrote:
It gets so frustrating sometimes, it isn't so black and white, there are
many levels of gray. The PostgreSQL project is trying so hard to be
neutral, that it is making itself irrelevant.
We are making ourselves irrelevant because we encourage the use
I wonder if there is a policy on when schema-qualified names should be used
in ereport/elog messages.
At the moment this doesn't seem to be consistent, even within the same
command:
template1=# VACUUM verbose t;
INFO: vacuuming "public.t"
[...]
template1=# VACUUM verbose tv;
WARNING: skipping
> On Sun, Jan 29, 2006 at 03:15:06PM -0500, Mark Woodward wrote:
>> > Postgres generally seems to favor extensibility over integration, and
>> I
>> > generally agree with that approach.
>>
>> I generally agree as well, but.
>>
>> I think there is always a balance between "out of the box" vs
>>
On Sun, Jan 29, 2006 at 03:15:06PM -0500, Mark Woodward wrote:
> > Postgres generally seems to favor extensibility over integration, and I
> > generally agree with that approach.
>
> I generally agree as well, but.
>
> I think there is always a balance between "out of the box" vs
> "extensibi
On Mon, Jan 30, 2006 at 10:25:39AM +0100, Thomas Hallgren wrote:
> Robert Treat wrote:
> >On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
> >>Mark Kirkwood said:
> >> ...
> >>A nicer idea would be something like a utility could we ship that will
> >>download, build and install module foo for
On Mon, Jan 30, 2006 at 10:01:58PM +0800, Christopher Kings-Lynne wrote:
>
>
> Andrew Dunstan wrote:
> >
> >
> >Michael Fuhr wrote:
> >
> >>On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
> >>
> >>
> >>>On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
> >>>
> A nicer i
On 30 Jan 2006 11:35:13 -0500
Robert Treat <[EMAIL PROTECTED]> wrote:
> > >>> CPAN modules, Ruby gems, PgFoundry ingots? :)
> > >>>
> > >>
> > >> Tusks? (Extensions of the elephant.)
> > >>
> > >>
> > >>
> > >
> > > Trunks?
> >
> > Dung?
> >
>
> gives a whole new meaning to the term "pa
On Mon, 2006-01-30 at 09:01, Christopher Kings-Lynne wrote:
>
>
> Andrew Dunstan wrote:
> >
> >
> > Michael Fuhr wrote:
> >
> >> On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
> >>
> >>
> >>> On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
> >>>
> A nicer idea
On Mon, 2006-01-30 at 08:25, Andrew Dunstan wrote:
>
>
> Josh Berkus wrote:
>
> >Andrew,
> >
> >
> >
> >>A nicer idea would be something like a utility could we ship that
> >>will
> >>download, build and install module foo for you. Then we could publish
> >>many
> >>many modules on pgfoundry,
> Hi,
> Does anyone know how the win32 server checks if the user is
> non priveleged? Does it just check if the user is in the
> admin or power user group?
Yes and yes. See
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/port/win32/
security.c?rev=1.9
//Magnus
---
Hi,
Does anyone know how the win32 server checks if the user is non
priveleged? Does it just check if the user is in the admin or power
user group?
Thanks,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com
---
"William ZHANG" <[EMAIL PROTECTED]> writes:
> Another problem is, should we allow any circles to be formed when executing
> GRANTs?
This is already prohibited.
regards, tom lane
---(end of broadcast)---
TIP 3: Have you check
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> I tried replacing it with:
> UPDATE food_foods SET included=(verification_status = 'I');
> However, that set included to true only where verification_status=I, it
> didn't set false at all.
You'd have gotten NULL, not FALSE, at the rows where
On 1/27/2006 10:56 AM, Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I think this is unquestionably
a bug, at least for autovacuum's purposes --- though it might be OK
for the original intent of the stats system, which was simply to track
activity levels.
Any thou
On 1/27/2006 10:53 AM, Alvaro Herrera wrote:
Tom Lane wrote:
I think this is the fault of the stats system design. AFAICT from a
quick look at the code, inserted/updated/deleted tuples are reported
to the collector in the same way regardless of whether the sending
transaction committed or roll
Andrew Dunstan wrote:
Michael Fuhr wrote:
On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
A nicer idea would be something like a utility could we ship that will
download, build and install module foo for you.
"kevin brintnall" <[EMAIL PROTECTED]>
...
> (SQL99, 10.5 , General Rules, 15-18)
>
> 15) SELECT with neither nor list> specifies the SELECT privilege on all columns of T including any
> ^
>columns subsequently added to
Hello Hackers,
_bt_pgaddtup, called by _bt_split, always sets the LP_USED flag
and after that the following transactions access the heap data (which resides on
disk) to check whether the tuple is alive. But this is unnessesary when the
original tuple is not alive, because in this case the new ite
Michael Fuhr wrote:
On Mon, Jan 30, 2006 at 12:20:25PM +0900, Michael Glaesemann wrote:
On Jan 30, 2006, at 12:23 , Andrew Dunstan wrote:
A nicer idea would be something like a utility could we ship that will
download, build and install module foo for you.
CPAN modules, Ruby
Josh Berkus wrote:
Andrew,
A nicer idea would be something like a utility could we ship that
will
download, build and install module foo for you. Then we could publish
many
many modules on pgfoundry, their authors could look after them, and
installing them would be trivial. pgxs should ma
Magnus Hagander wrote:
I want to create the litest possible setup for use in my IM
server (Lightning Messenger), and eliminate any unneeded
files so I can have the smallest setup I can get.
I already have a complete working setup built with Inno
setup(it's 4.8 mb), now I just need to get i
> > It's used for ecpg, IIRC, when compiled in thread-safe mode.
> >
> > //Magnus
>
>
> Thanks Magnus,
> Here is another question for you.
> Is it documented anywhere or does someone know what is the
> bare minimum requirements to run the server on a production box?
No, I don't think so :-)
On Mon, Jan 30, 2006 at 10:25:39AM +0100, Thomas Hallgren wrote:
> >Actually I don't think it would be all that hard. You just need to have
> >each project produce an xml file with bits of package information (name,
> >dependencies, version info, etc...) which could then be combined with all
> >
On Mon, Jan 30, 2006 at 04:44:21PM +0800, Christopher Kings-Lynne wrote:
> I had this code in a script:
>
> UPDATE food_foods SET included=true WHERE verification_status = 'I';
> UPDATE food_foods SET included=false WHERE verification_status IS NULL;
>
> I tried replacing it with:
>
> UPDATE foo
Robert Treat wrote:
On Sunday 29 January 2006 22:23, Andrew Dunstan wrote:
Mark Kirkwood said:
>> ...
A nicer idea would be something like a utility could we ship that will
download, build and install module foo for you. Then we could publish many
many modules on pgfoundry, their authors could
>> 2. deal with circles in GRANT graph.
>
> Can you give an examle for how this is any different for column-level
> GRANTs?
When judging if there are any circles in the grant graph, we can represent
table priviledges as column priviledges, thus make things easier. I have not
think hard enought to
I had this code in a script:
UPDATE food_foods SET included=true WHERE verification_status = 'I';
UPDATE food_foods SET included=false WHERE verification_status IS NULL;
I tried replacing it with:
UPDATE food_foods SET included=(verification_status = 'I');
However, that set included to true on
70 matches
Mail list logo
