Обсуждение: Does pgadmin4 work with postgresql 8.4?
The subject says it all. I am using a very old database that I cant upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4?
Thanks,
~Ben
~Ben
On 8/5/19 1:15 PM, Benedict Holland wrote: > The subject says it all. I am using a very old database that I cant > upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4? Trolling the docs does not offer any insight. If you have pgAdmin4 already installed I would just set up a connection to the 8.4 instance and see if it works:) > > Thanks, > ~Ben -- Adrian Klaver adrian.klaver@aklaver.com
Yea. I did look in the doc's. What I really dont want is some strange feature that is unique to 8.4 not have support. Like, a select option for example. I am fairly sure most of it will work but my "not supported" does it mean that it wasnt tested but will probably work or that it really isnt supported at all. Either is fine as I can use pgadmin3 if I have to but I would prefer at least 1 piece of software to have support rather than none.
Thanks,
~Ben
~Ben
On Mon, Aug 5, 2019, 4:48 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 8/5/19 1:15 PM, Benedict Holland wrote:
> The subject says it all. I am using a very old database that I cant
> upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4?
Trolling the docs does not offer any insight. If you have pgAdmin4
already installed I would just set up a connection to the 8.4 instance
and see if it works:)
>
> Thanks,
> ~Ben
--
Adrian Klaver
adrian.klaver@aklaver.com
On 8/5/19 1:51 PM, Benedict Holland wrote: > Yea. I did look in the doc's. What I really dont want is some strange > feature that is unique to 8.4 not have support. Like, a select option > for example. I am fairly sure most of it will work but my "not > supported" does it mean that it wasnt tested but will probably work or > that it really isnt supported at all. Either is fine as I can use > pgadmin3 if I have to but I would prefer at least 1 piece of software to > have support rather than none. You might have more luck getting a definitive answer here: https://www.postgresql.org/list/pgadmin-support/ > > Thanks, > ~Ben > > On Mon, Aug 5, 2019, 4:48 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > On 8/5/19 1:15 PM, Benedict Holland wrote: > > The subject says it all. I am using a very old database that I cant > > upgrade. Do I have to manage it with pgadmin3 or can I use > postgresql 4? > > Trolling the docs does not offer any insight. If you have pgAdmin4 > already installed I would just set up a connection to the 8.4 instance > and see if it works:) > > > > > Thanks, > > ~Ben > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
>What I really dont want is some strange
> feature that is unique to 8.4 not have support.
Actually, the reverse is more likely. Newer versions of PostgreSQL have newer and additional
features, so it is highly unlikely that PgAdmin4 would not be able to support all features in 8.4.
That being said, what is the specific reason you cannot upgrade to a newer version of PostgreSQL?
On Mon, Aug 5, 2019 at 5:11 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 8/5/19 1:51 PM, Benedict Holland wrote:
> Yea. I did look in the doc's. What I really dont want is some strange
> feature that is unique to 8.4 not have support. Like, a select option
> for example. I am fairly sure most of it will work but my "not
> supported" does it mean that it wasnt tested but will probably work or
> that it really isnt supported at all. Either is fine as I can use
> pgadmin3 if I have to but I would prefer at least 1 piece of software to
> have support rather than none.
You might have more luck getting a definitive answer here:
https://www.postgresql.org/list/pgadmin-support/
>
> Thanks,
> ~Ben
>
> On Mon, Aug 5, 2019, 4:48 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 8/5/19 1:15 PM, Benedict Holland wrote:
> > The subject says it all. I am using a very old database that I cant
> > upgrade. Do I have to manage it with pgadmin3 or can I use
> postgresql 4?
>
> Trolling the docs does not offer any insight. If you have pgAdmin4
> already installed I would just set up a connection to the 8.4 instance
> and see if it works:)
>
> >
> > Thanks,
> > ~Ben
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
No, pgAdmin4 only supports PostgreSQL 9.2 and later versions.
On Tue, 6 Aug 2019, 01:45 Benedict Holland, <benedict.m.holland@gmail.com> wrote:
The subject says it all. I am using a very old database that I cant upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4?
Thanks,
~Ben
On 8/5/19 7:04 PM, Murtuza Zabuawala wrote: > No, pgAdmin4 only supports PostgreSQL 9.2 and later versions. Where is that mentioned in the documentation? > > On Tue, 6 Aug 2019, 01:45 Benedict Holland, > <benedict.m.holland@gmail.com <mailto:benedict.m.holland@gmail.com>> wrote: > > The subject says it all. I am using a very old database that I cant > upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4? > > > Thanks, > ~Ben > -- Adrian Klaver adrian.klaver@aklaver.com
On Tue, Aug 6, 2019 at 7:57 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 8/5/19 7:04 PM, Murtuza Zabuawala wrote:
> No, pgAdmin4 only supports PostgreSQL 9.2 and later versions.
Where is that mentioned in the documentation?
It is mentioned on the front page of https://www.pgadmin.org/
(Check introduction texts on the elephant wallpaper)
-- Murtuza
>
> On Tue, 6 Aug 2019, 01:45 Benedict Holland,
> <benedict.m.holland@gmail.com <mailto:benedict.m.holland@gmail.com>> wrote:
>
> The subject says it all. I am using a very old database that I cant
> upgrade. Do I have to manage it with pgadmin3 or can I use postgresql 4?
>
>
> Thanks,
> ~Ben
>
--
Adrian Klaver
adrian.klaver@aklaver.com
On Tue, Aug 6, 2019 at 7:02 AM Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote: > It is mentioned on the front page of https://www.pgadmin.org/ > (Check introduction texts on the elephant wallpaper) "pgAdmin may be used on Linux, Unix, Mac OS X and Windows to manage PostgreSQL 9.2 and above." However, I would suspect it can work even on older versions. Luca
We cant upgrade because of business reasons but that is very high on our agenda to fix. To me, there is a huge difference between unsupported and wont work. I dont expect support for this but are there significant changes between 8.4 and 9.2 that would prevent pgadmin4 from working?
Thanks,
~Ben
~Ben
On Tue, Aug 6, 2019, 3:21 AM Luca Ferrari <fluca1978@gmail.com> wrote:
On Tue, Aug 6, 2019 at 7:02 AM Murtuza Zabuawala
<murtuza.zabuawala@enterprisedb.com> wrote:
> It is mentioned on the front page of https://www.pgadmin.org/
> (Check introduction texts on the elephant wallpaper)
"pgAdmin may be used on Linux, Unix, Mac OS X and Windows to manage
PostgreSQL 9.2 and above."
However, I would suspect it can work even on older versions.
Luca
8.4's final release was 5 years ago, so unlikely anyone would know the answer to your question.
The only way to really know is to try it.
I just had an issue with the current version (4.11) against PG11.4, where the version of psycopg2 was out of date by a release (2.7x instead of 2.8). Most stuff works, but there are a few things that don't.
Based on that example, I reckon any reply either way is pure guesswork.
On Tue, 6 Aug 2019 at 14:46, Benedict Holland <benedict.m.holland@gmail.com> wrote:
We cant upgrade because of business reasons but that is very high on our agenda to fix. To me, there is a huge difference between unsupported and wont work. I dont expect support for this but are there significant changes between 8.4 and 9.2 that would prevent pgadmin4 from working?
On 8/5/19 10:02 PM, Murtuza Zabuawala wrote: > On Tue, Aug 6, 2019 at 7:57 AM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > On 8/5/19 7:04 PM, Murtuza Zabuawala wrote: > > No, pgAdmin4 only supports PostgreSQL 9.2 and later versions. > > Where is that mentioned in the documentation? > > > It is mentioned on the front page of https://www.pgadmin.org/ > (Check introduction texts on the elephant wallpaper) Making a request that it be included in the actual documentation, say here: https://www.pgadmin.org/docs/pgadmin4/latest/getting_started.html It's current location is obscured by the wallpaper and hidden by the screenshot as you mouse over it. > > -- Murtuza > > > > > > On Tue, 6 Aug 2019, 01:45 Benedict Holland, > > <benedict.m.holland@gmail.com > <mailto:benedict.m.holland@gmail.com> > <mailto:benedict.m.holland@gmail.com > <mailto:benedict.m.holland@gmail.com>>> wrote: > > > > The subject says it all. I am using a very old database that > I cant > > upgrade. Do I have to manage it with pgadmin3 or can I use > postgresql 4? > > > > > > Thanks, > > ~Ben > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
On Tue, Aug 6, 2019 at 2:46 PM Benedict Holland <benedict.m.holland@gmail.com> wrote: > > To me, there is a huge difference between unsupported and wont work. ote: Thta' why the only truly working software you has is psql 8.4. As other has stated, it is too far in the past to say what is working and what not, you have to walk thru the release notes and find yourself which features are not going to work. Or stick with psql. Good luck, Luca
On 8/6/19 9:11 AM, Luca Ferrari wrote: > On Tue, Aug 6, 2019 at 2:46 PM Benedict Holland > <benedict.m.holland@gmail.com> wrote: >> >> To me, there is a huge difference between unsupported and wont work. ote: > > Thta' why the only truly working software you has is psql 8.4. > As other has stated, it is too far in the past to say what is working > and what not, you have to walk thru the release notes and find > yourself which features are not going to work. Or stick with psql. Or as the OP stated earlier use pgAdmin3. It works with Postgres 7.3 up to something in the 9.X.x range(I believe). It is EOL also, but you do what you gotta do. > > Good luck, > Luca > -- Adrian Klaver adrian.klaver@aklaver.com