Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen

How can I add custom dictionary to aurora postgres

0

We need a working fulltext search on aurora postgres, so we need to create a custom dictionary. How can we install/upload the dictionary files to the server.

  • please accept the answer if it was useful for you

gefragt vor 8 Monaten382 Aufrufe
1 Antwort
1

Unlike a self-managed PostgreSQL server, you can't directly access the file system of an Aurora instance to place your dictionary files. However, there are workarounds:

  • Use AWS S3 and Data Migration Service (DMS): You can upload your dictionary files to an S3 bucket and then use AWS DMS or other AWS data migration tools to transfer data to your Aurora instance. This approach usually involves loading data into tables rather than directly manipulating server configurations.

  • Use pgAdmin or SQL Workbench: For some custom configurations, you might be able to use SQL-based tools like pgAdmin or SQL Workbench to execute SQL commands that modify the database's text search configuration. This method won't directly upload files but can be used to tweak settings or upload the contents of dictionary files to tables.

profile picture
EXPERTE
beantwortet vor 8 Monaten
profile picture
EXPERTE
überprüft vor 8 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen