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
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
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 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
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 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 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 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
>
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)
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
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
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 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.
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
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
Hi,
Is it possible to declare a UNIQUE constraint that uses GIN indexing?
If so, what would the definition look like?
Allan.
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
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 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
19 matches
Mail list logo
