Thread: 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,
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,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 descriptionswhen 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.