Regarding postgresql installation on Google Cloud [Error]
Hello,
I am Paul, Kim who utilizing postgresql database in google cloud Debian
linux environment to do my role.
As reading and applying information on postgresql website, regards of
version 10, 13, 14 of postgresql,
- https://www.postgresql.org/download/linux/debian/
- https://wiki.postgresql.org/wiki/Apt
- https://www.postgresql.org/docs/current/supported-platforms.html
Database is normally working well, and I had create User, Grand,
Extension, Function. however, *there are some errors in debian shell log
after installation as following descriptions*
when after set up the configuration files, and environment file, service
files to start server up, the problem occurs even though compatibility is
right.
- *ERROR : function aurora_version() does not exist at character 8*
- HINT : No function matches the given name and argument types. You
might need to add explicit type casts
- STATEMENT : select AURORA_VERSION();
as my research information aurora_version is included in AWS
environment.
I would like to ask your help regards of how to proceed postgresql server
start up on Google Cloud Platform host environment. and what version and
installation method is proper with Debian 10 or 11 version.
Thank you,
Paul.
On Mon, May 16, 2022 at 1:36 PM 김범승 <paul.kim@brackets.solutions> wrote:
Hello,
I am Paul, Kim who utilizing postgresql database in google cloud Debian
linux environment to do my role.As reading and applying information on postgresql website, regards of
version 10, 13, 14 of postgresql,
- https://www.postgresql.org/download/linux/debian/
- https://wiki.postgresql.org/wiki/Apt
- https://www.postgresql.org/docs/current/supported-platforms.htmlDatabase is normally working well, and I had create User, Grand,
Extension, Function. however, *there are some errors in debian shell log
after installation as following descriptions*when after set up the configuration files, and environment file, service
files to start server up, the problem occurs even though compatibility is
right.
- *ERROR : function aurora_version() does not exist at character 8*
- HINT : No function matches the given name and argument types. You
might need to add explicit type casts
- STATEMENT : select AURORA_VERSION();as my research information aurora_version is included in AWS
environment.I would like to ask your help regards of how to proceed postgresql server
start up on Google Cloud Platform host environment. and what version and
installation method is proper with Debian 10 or 11 version.
Your question seems to be about Aurora, not about PostgreSQL. The function
you refer to does not exist in PostgreSQL. You will have to contact AWS for
support on Aurora functionality and your software vendor on whether it can
be ported to an actual PostgreSQL database.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>