Fwd: Posgress 8.3
I ran posgress 8.3. I have a database about 90Mb. 23066 sequences and 2083
table
[image: Capture.JPG]
When I back up the data it says this error.
out of shared memory
help me
[image: picturemessage_znwcidiq.hdy.png]
Import Notes
Reply to msg id not found: CAPxY4BRDy8UeA9DiGFzFy=XgGg7mi3oRYGgaPPcedj6bkUjx5g@mail.gmail.comReference msg id not found: CAPxY4BRDy8UeA9DiGFzFy=XgGg7mi3oRYGgaPPcedj6bkUjx5g@mail.gmail.com
Hi,
We do not support PostgreSQL 8.3. We are supporting PostgreSQL v9.5 till
v13 and 9.5 will be obsoleted on February 11, 2021
Please refer to the versioning policy for more details:
https://www.postgresql.org/support/versioning/
Please note that we don't support pgadminIII any more, kindly use latest
version of pgadmin4:
https://www.pgadmin.org/download/
On Tue, Dec 1, 2020 at 2:27 PM Hóa Phan <hoaphan91ht@gmail.com> wrote:
I ran posgress 8.3. I have a database about 90Mb. 23066 sequences and 2083
table
[image: Capture.JPG]
When I back up the data it says this error.
out of shared memory
help me
[image: picturemessage_znwcidiq.hdy.png]
--
Fahar Abbas
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com
On Tue, Dec 1, 2020 at 10:27 AM Hóa Phan <hoaphan91ht@gmail.com> wrote:
I ran posgress 8.3. I have a database about 90Mb. 23066 sequences and 2083
table
[image: Capture.JPG]
When I back up the data it says this error.
out of shared memory
help me
[image: picturemessage_znwcidiq.hdy.png]
230000 sequences is... A lot :)
That said, the error message gives you a hint of what to try. Did you try
to increase max_locks_per_transaction as it says?
And as has been already said, your 8.3 version is extremely out of date. It
went out of support in 2013, coming up on 8 years ago. You need to upgrade
that right away -- but of course, you need to dump your data in order to do
that....
/Magnus