On Thu, Feb 13, 2025 at 9:44 PM Thiemo Kellner
wrote:
> 13.02.2025 10:54:05 Achilleas Mantzios - cloud <
> a.mantz...@cloud.gatewaynet.com>:
>
> > If we followed a strict normalized approach then we would create
> additionally 11 tables each tag of type c) . And we are not guaranteed that
> the s
I am not sure if this is the right place to post a PostgreSQL + Retrieval
Augmented Generation (RAG) question, but I have tried other sites but I did
not receive any response.
I have managed to use RAG to query data in a PostgreSQL table using Python
and the lanchain_community module.
But I have
On Tue, Jan 30, 2024 at 12:27 PM Justin Clift wrote:
> On 2024-01-30 15:52, Allan Kamau wrote:
> > I am trying to build a singularity image from postgres docker image.
> > I am issuing the command below.
> >
> > $ singularity build /local/data/some/postgres.16.
I am trying to build a singularity image from postgres docker image.
I am issuing the command below.
$ singularity build /local/data/some/postgres.16.1.sif
docker://postgres/postgres:16.1
INFO:Starting build...
INFO:Fetching OCI image...
FATAL: While performing build: conveyor failed to
On Thu, Oct 27, 2022 at 12:18 PM Peter J. Holzer wrote:
> On 2022-10-27 10:55:31 +0300, Kristjan Mustkivi wrote:
> > We use dockerized postgres.
>
> So that means you aren't just replacing PostgreSQL, but your complete OS
> (except the kernel). What is the source of your docker images? Do they
>
On Thu, Oct 27, 2022 at 10:26 AM Allan Kamau wrote:
>
>
> On Thu, Oct 27, 2022 at 10:20 AM Kristjan Mustkivi
> wrote:
>
>> Dear community,
>>
>> Right after upgrading our postgres servers from 11.15 to 11.17 we
>> started to encounter problems with data.
On Thu, Oct 27, 2022 at 10:20 AM Kristjan Mustkivi
wrote:
> Dear community,
>
> Right after upgrading our postgres servers from 11.15 to 11.17 we
> started to encounter problems with data. Namely, when the query hit
> the index, it returned a single row; when the query hit a relation
> directly,
On Sun, Jun 27, 2021 at 9:41 PM Tom Lane wrote:
> "David G. Johnston" writes:
> > On Sun, Jun 27, 2021 at 11:18 AM Allan Kamau
> wrote:
> >> Is it possible to declare a UNIQUE constraint that uses GIN indexing?
>
> > Doesn't seem to be possibl
Hi,
Is it possible to declare a UNIQUE constraint that uses GIN indexing?
If so, what would the definition look like?
Allan.
On Sat, Apr 3, 2021 at 1:59 PM Joao Miguel Ferreira <
joao.miguel.c.ferre...@gmail.com> wrote:
> Hello all,
>
> I have a big set of migration queries (that I do not control) that I must
> run on my automatic test database, in order to set ip up and run tests.
> These queries create all sorts of th
On Sat, Mar 20, 2021 at 6:52 PM Ron Clarke wrote:
> /*
> I'm trying to port a system from SQL server, and at the same time better
> learn postgreSQL.
>
> I've come across a problem that is easily solved in that world, but I am
> struggling to find an approach in postgres that works.
>
> We have 2
A good place to start would be here "
https://www.postgresql.org/docs/13/user-manag.html"; and "
https://www.postgresql.org/docs/13/client-authentication.html"; and "
https://www.postgresql.org/docs/current/ssl-tcp.html";
Additionally.
1) You may need to look into securing access to the physical s
On Thu, Oct 8, 2020 at 10:16 PM Jean-Marc Lessard <
jean-marc.less...@ultra-ft.com> wrote:
> I have a large table (billions of records) which has not been vacuum and
> bloated.
>
> Vacuum scale factor was left at the default.
>
>
>
> I ran a vacuum on a DEV system and it makes several passes (scan
You may write stored procedures using PL/pgSQL,alternatively you may
write your queries in python.
You may use psycopg2 to query the DB from Python.
You may have a mix of the two, it will depend on your preference.
Ideally you may not want your users running queries against the data by
connecting t
On Tue, May 5, 2020 at 5:28 PM Adrian Klaver
wrote:
> On 5/5/20 7:13 AM, Wolff, Ken L wrote:
> > Hi, everyone. Wondering if there’s a way in PostgreSQL to automatically
> > lock accounts after a number of failed logins (a security requirement
> > for my organization). I’ve been investigating th
Some of the aspects you may want to consider are:
1) Per unit time (day or week), how much data will be persisted to the
database, number of records and total size of the data.
2) How much of these data will be updated and how frequently in a given
time unit (day or week).
3) Will the databases hos
Thank you very much Paul. Your suggestions and input have spared me many
hours of trying to identify applications and functions to perform this
transformation.
I am now installing PostGIS.
Allan.
On Wed, Dec 5, 2018 at 1:25 AM Paul Ramsey
wrote:
>
> On Dec 4, 2018, at 12:36 PM, Allan
I have data that contains geographic coordinate values in various
geographic coordinate system formats such as "degrees minutes seconds" and
"degrees decimal minutes".
I would like to convert these geographic coordinate values into decimal
degrees format.
Does PostgreSQL (more specifically PostGIS)
On Mon, May 14, 2018 at 2:22 PM, Yashwanth Govinda Setty <
ygovindase...@commvault.com> wrote:
> Hi all,
>
>
>
> We are facing this problem while performing file system level backup of
> database files:
>
> As each database will form a directory inside Base directory which
> consists of files repr
19 matches
Mail list logo
