question about the admin contrib module and binary RPMs

Hi,

On Wed, 2006-03-22 at 13:31 -0600, Tony Caduto wrote:

I just updated my CentOS box to Postgresql 8.1.3 and installed the
contrib rpm and I can't find the admin81 stuff anywhere.
My question is how come this is not included in the RPM based binary
distrubution?

Admin81 stuff is not a part of PostgreSQL RPMs -- it is a part of
pgadmin3 project.

That RPM in in my short term todo list with the up2date pgadmin rpm.
I'Ll announce to pgadmin list as soon as it is available.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/

Devrim GUNDUZ wrote:

Admin81 stuff is not a part of PostgreSQL RPMs -- it is a part of
pgadmin3 project.

gards,

Hi,

I understand it was created by the pgAdmin project, but don't you think
it would be better to be with the rest of the contrib modules? I and
many others don't want to install a pgadmin rpm on a server that has no
GUI, that would not make any sense at all.

It's meant to be used on a server, so it should be part of the contrib rpm.

Thanks,

Tony

Tony Caduto wrote:

Devrim GUNDUZ wrote:

Admin81 stuff is not a part of PostgreSQL RPMs -- it is a part of
pgadmin3 project.

gards,

Hi,

I understand it was created by the pgAdmin project, but don't you think
it would be better to be with the rest of the contrib modules? I and
many others don't want to install a pgadmin rpm on a server that has no
GUI, that would not make any sense at all.

It's meant to be used on a server, so it should be part of the contrib rpm.

As far as I can tell there is no admin813 contrib module... I am looking
at my 8.1.3 source install and there is no contrib module named that???

If the pgAdmin folks would like to submit it to PostgreSQL contrib that
is a different argument.

Joshua D. Drake

As far as I can tell there is no admin813 contrib module... I am
looking at my 8.1.3 source install and there is no contrib module
named that???

If the pgAdmin folks would like to submit it to PostgreSQL contrib
that is a different argument.

Joshua D. Drake

Hi Joshua,

You are correct, it's not in the source install. Right now it's only
included in the win32 installer contrib directory.
I am trying to get the point accross that it needs to be included in the
Linux binary rpms as well.

In 8.1 some of the admin module functions have been moved to the
backend, and maybe the rest will be moved with 8.2, I don't know for sure.
Maybe the PG Admin guys can shed some light on this?

If you want to use it and you use the rpms it's a big pain because you
need the source install to compile and install it.

Later,

Tony

Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:

I understand it was created by the pgAdmin project, but don't you think
it would be better to be with the rest of the contrib modules?

Except it isn't one of the contrib modules. The fact that you think of
it as being like them doesn't make it one of them.

I and many others don't want to install a pgadmin rpm on a server that
has no GUI, that would not make any sense at all.

Which is one very good reason why it should be a separate RPM, no? If
it were in the contrib RPM then you could not install that RPM *at all*
on a machine that didn't have all of pgadmin's dependencies. I don't
know offhand what its dependencies are, but I'd imagine they include a
fair number of "GUI" packages.

regards, tom lane

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
Sent: 22 March 2006 21:31
To: Tony Caduto
Cc: Devrim GUNDUZ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] question about the admin contrib
module and binary

Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:

I understand it was created by the pgAdmin project, but

don't you think

it would be better to be with the rest of the contrib modules?

Except it isn't one of the contrib modules. The fact that
you think of
it as being like them doesn't make it one of them.

Well in fairness to Tony we do refer to it as a 'contrib' module, but
that's because it uses the contrib build system (or PGXS in SVN trunk).

I and many others don't want to install a pgadmin rpm on a

server that

has no GUI, that would not make any sense at all.

Which is one very good reason why it should be a separate RPM, no? If
it were in the contrib RPM then you could not install that
RPM *at all*
on a machine that didn't have all of pgadmin's dependencies. I don't
know offhand what its dependencies are, but I'd imagine they include a
fair number of "GUI" packages.

Yeah - wxWidgets, GTK etc. but none are required by the admin module,
only by pgAdmin itself on the users workstation. Devrim has said he will
build it as a separate RPM - in the meantime a source tarball can be
downloaded from http://www.pgadmin.org/download/adminpacks.php, or the
PGXS compatible versions can be found in SVN under
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/xtra/

Regards, Dave

Which is one very good reason why it should be a separate RPM, no? If
it were in the contrib RPM then you could not install that RPM *at all*
on a machine that didn't have all of pgadmin's dependencies. I don't
know offhand what its dependencies are, but I'd imagine they include a
fair number of "GUI" packages.

regards, tom lane

Hi Tom,
I don't think it has any PG Admin dependencies, it's just a set of c
functions that allow the user to manipulate files
on the server. i.e. for updating the pg_hba.conf and the postgresql.conf.

It needs a source install of Postgresql not pgAdmin to compile.

All I am trying to say is that it should be included in this file:
postgresql-contrib-8.1.3-1PGDG.i686.rpm
so binary linux users can use it almost as easy as the binary win32 users.

Later,

Tony

Dave Page wrote:

Well in fairness to Tony we do refer to it as a 'contrib' module, but
that's because it uses the contrib build system (or PGXS in SVN trunk).

Devrim has said he will
build it as a separate RPM - in the meantime a source tarball can be
downloaded from http://www.pgadmin.org/download/adminpacks.php, or the
PGXS compatible versions can be found in SVN under
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/xtra/

Hi Dave,
a seperate rpm would be fine as long as it is just the admin module stuff.
I wasn't clear on Devrim's first response, it sounded like he was going
to make a seperate pgAdmin rpm that included
the admin module.

Later,

Tony

"Dave Page" <dpage@vale-housing.co.uk> writes:

Yeah - wxWidgets, GTK etc. but none are required by the admin module,
only by pgAdmin itself on the users workstation.

Oh, so what we're talking about is some server-side support functions
for the pgAdmin client? OK, that's not what I was envisioning. From
a dependency standpoint it might be OK to package that as a contrib
module. I would say the main point for or against is whether you are
ready to tie the releases of the support functions to releases of the
core server. If they should naturally go with pgAdmin releases then
it'd be sticky to have them in contrib.

There's also a licensing issue which is that pgAdmin is GPL, while
we're trying to make sure that all contrib modules are licensed
the same as the core server.

regards, tom lane

Hi,

On Wed, 2006-03-22 at 15:52 -0600, Tony Caduto wrote:

All I am trying to say is that it should be included in this file:
postgresql-contrib-8.1.3-1PGDG.i686.rpm
so binary linux users can use it almost as easy as the binary win32
users.

It won't happen, because adminpack is not in contrib part of PostgreSQL
Core source.

Anyway, give me a few days for the adminpacks RPM. The source file
stands on my Desktop.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/

There's also a licensing issue which is that pgAdmin is GPL,
while we're trying to make sure that all contrib modules are
licensed the same as the core server.

No, pgAdmin is Artistic License, not GPL.

Still not BSD, tough, so the argument still holds even if the difference
isn't as big.

//Magnus

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 22 March 2006 22:02
To: Dave Page
Cc: Tony Caduto; Devrim GUNDUZ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] question about the admin contrib
module and binary

"Dave Page" <dpage@vale-housing.co.uk> writes:

Yeah - wxWidgets, GTK etc. but none are required by the

admin module,

only by pgAdmin itself on the users workstation.

Oh, so what we're talking about is some server-side support functions
for the pgAdmin client? OK, that's not what I was envisioning. From
a dependency standpoint it might be OK to package that as a contrib
module. I would say the main point for or against is whether you are
ready to tie the releases of the support functions to releases of the
core server. If they should naturally go with pgAdmin releases then
it'd be sticky to have them in contrib.

They're primarily tied to the PostgreSQL version, however, what I see as
the bigger problem is that 99% of what is in there has been rejected for
inclusion in the core server because (mainly) you wanted to find better
ways of achieving what we were doing - think pg_file_write(). However,
if you're happy to have them in /contrib that might well make life
easier until we come up with acceptable alternatives for core (as it
happens I submitted a discussion proposal for the conference precisely
to hash out the remote config management stuff).

There's also a licensing issue which is that pgAdmin is GPL, while
we're trying to make sure that all contrib modules are licensed
the same as the core server.

Yeuch, not GPL - Artistic. But that shouldn't cause any problems - there
are only 3 ppl who have ever worked on it and I wouldn't see a licence
change being a issue.

Regards, Dave.

"Dave Page" <dpage@vale-housing.co.uk> writes:

There's also a licensing issue which is that pgAdmin is GPL, while
we're trying to make sure that all contrib modules are licensed
the same as the core server.

Yeuch, not GPL - Artistic.

Oh, my mistake, I looked at the phppgadmin home page not pgadmin's.
But relicensing the proposed contrib code to BSD would definitely make
it an easier sale.

regards, tom lane