Greetings,
Please don't top-post on the PG mailing lists, it makes it harder to
follow the discussion.
* Marco Fortina (marco_fort...@hotmail.it) wrote:
> https://commitfest.postgresql.org/42/3867/ is not exacly what I proposed as
> new feature to developers.
I understood what you were proposin
Greetings,
* Imre Samu (pella.s...@gmail.com) wrote:
> Theory: Maybe the search doesn't always work ...
It does ... but perhaps not as expected (or as ideal).
> Is this a known problem?
Yes and no.
> My use case:
> in https://www.postgresql.org/list/ -> "Search the Archives"
> search for the
Greetings,
* Ghislain ROUVIGNAC (g...@sylob.com) wrote:
> Portworx says that on a running PostgreSQL it can:
>
>- replicate volumes for failover
>- take snapshots of volumes
>- backup volumes
The downside with any snapshot-style approach is that it means that when
you have a failure,
Greetings,
* Laurenz Albe (laurenz.a...@cybertec.at) wrote:
> Stephen Frost wrote:
> > The downside with any snapshot-style approach is that it means that when
> > you have a failure, you have to go through and replay all the WAL since
> > the last checkpoint, which is si
Greetings,
* Ghislain ROUVIGNAC (g...@sylob.com) wrote:
> Our application don't write lot of data, so i don't think the time taken on
> replaying the WAL will be an issue for us.
That certainly makes things simpler.
Then again, if you are not writing a lot of data then you might consider
using s
Greetings,
* Torsten Förtsch (tfoertsch...@gmail.com) wrote:
> I am working on restoring a database from a base backup + WAL. With the
> default settings the database replays about 3-4 WAL files per second. The
> startup process takes about 65% of a CPU and writes data with something
> between 50
Greetings,
* Jeff Janes (jeff.ja...@gmail.com) wrote:
> One way I found to speed up restore_command is to have another program run
> a few WAL files ahead of it, copying the WAL from the real archive into a
> scratch space which is on the same filesystem as pg_xlog/pg_wal. Then have
> restore_com
Greetings,
* Ravi Krishna (srkrish...@aol.com) wrote:
> > There is no such thing as a "read only" table in PostgreSQL. All tables
> > are read/write no matter that frequency of either event. There is nothing
> > > inherently special about "no writes for 4 days" and "no writes for 10
> > secon
Greetings,
* Michael Paquier (mich...@paquier.xyz) wrote:
> On Thu, Nov 01, 2018 at 07:06:32PM -0400, Stephen Frost wrote:
> > No, we don't currently track that information but it's an interesting
> > idea, at least imv.
>
> What would be the use case for it? W
Greetings,
* Олег Самойлов (spl...@ya.ru) wrote:
> Ah, thanks. I am not a developer of PostgreSQL. I am a developer in
> PostgreSQL. :) And I see two hash indexes on the same data and one of them 43
> times bigger then other, this looked like something terribly wrong. Just free
> idea how to co
Greetings,
* Tom Lane (t...@sss.pgh.pa.us) wrote:
> Maybe I'm missing something, but doesn't this solve your problem
> as stated?
>
> ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO public;
That just means that the 'ROLE' in the result is the current role, as
per the docs:
Greetings,
* Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
> https://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2018
>
> As mentioned there, the slides are linked, as long as they have been
> delivered by the speakers, in the talk descriptions in the schedule.
I'm n
Greetings,
* Magnus Hagander (mag...@hagander.net) wrote:
> This has now been pushed, so both the schedule and the session list on
> pgconf.eu will now indicate which sessions have slides uploaded.
That's better, but couldn't we make that an actual link..?
Thanks!
Stephen
signature.asc
Descri
Greetings,
* Achilleas Mantzios (ach...@matrix.gatewaynet.com) wrote:
> On 19/11/18 3:27 μ.μ., Stephen Frost wrote:
> >* Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
> >>https://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2018
> >>
> &g
Greetings,
* Magnus Hagander (mag...@hagander.net) wrote:
> On Mon, Nov 19, 2018 at 4:01 PM Stephen Frost wrote:
> > * Magnus Hagander (mag...@hagander.net) wrote:
> > > This has now been pushed, so both the schedule and the session list on
> > > pgconf.eu will now i
Greetings,
* Magnus Hagander (mag...@hagander.net) wrote:
> On Mon, Nov 19, 2018 at 9:04 PM Stephen Frost wrote:
> > * Magnus Hagander (mag...@hagander.net) wrote:
> > > On Mon, Nov 19, 2018 at 4:01 PM Stephen Frost
> > wrote:
> > > > * Magnus
Greetings,
* Chris Withers (ch...@withers.org) wrote:
> We have an app that deals with a lot of queries, and we've been slowly
> seeing performance issues emerge. We take a lot of free form queries from
> users and stumbled upon a very surprising optimisation.
>
> So, we have a 'state' column whi
Greetings,
On Fri, Nov 30, 2018 at 07:52 Chris Withers wrote:
> On 28/11/2018 22:49, Stephen Frost wrote:
> > * Chris Withers (ch...@withers.org) wrote:
> >> We have an app that deals with a lot of queries, and we've been slowly
> >> seeing performance issues em
Greetings,
On Fri, Nov 30, 2018 at 08:00 Chris Withers wrote:
> On 30/11/2018 12:55, Stephen Frost wrote:
> > > I'd suggest you check out the wiki article written about this
> kind of
> > > question:
> > >
> > > https:
Greetings,
* Chris Withers (ch...@withers.org) wrote:
> On 28/11/2018 22:49, Stephen Frost wrote:
> >* Chris Withers (ch...@withers.org) wrote:
> >>We have an app that deals with a lot of queries, and we've been slowly
> >>seeing performance issues emerge. We take
Greetings,
* Andrew Gierth (and...@tao11.riddles.org.uk) wrote:
> > "Kenneth" == Kenneth Marshall writes:
>
> Kenneth> The individual queries run as expected, but when the OR
> Kenneth> condition is added, it never finishes.
>
> http://blog.rhodiumtoad.org.uk/2017/01/22/performance-issues
Greetings,
* Thomas Kellerer (spam_ea...@gmx.net) wrote:
> Stephen Frost schrieb am 30.11.2018 um 14:05:
> > PG doesn’t know, with complete certainty, that there’s only 3
> > values.
>
> Would the optimizer consult a check constraint ensuring that?
Not today, I don't
Greetings,
* Chris Withers (ch...@withers.org) wrote:
> On 30/11/2018 15:33, Stephen Frost wrote:
> >* Chris Withers (ch...@withers.org) wrote:
> >>On 28/11/2018 22:49, Stephen Frost wrote:
> >For this, specifically, it's because you end up with exactly what you
>
Greetings,
* Dejan Petrovic (dejan.petro...@islonline.com) wrote:
> I believe this is a result of my "broken" procedure for setting up a
> cascaded replica. I would love to know where the issue is.
[...]
> Notes:
> Machines are running on Centos 7, Postgresql 10.2
> DB-1 = master
> DB-2 = replic
Greetings,
* Ron (ronljohnso...@gmail.com) wrote:
> On 12/05/2018 08:42 AM, Chris Withers wrote:
> >On 05/12/2018 14:38, Stephen Frost wrote:
> >>>>* Chris Withers (ch...@withers.org) wrote:
> >>>Interesting! In my head, for some reason, I'd always assu
Greetings,
* Rene Romero Benavides (rene.romer...@gmail.com) wrote:
> Why do you need to know that ?
Please don't top-post, first, and second, it certainly seems like a
worthwhile thing to want to know, for a variety of reasons, such as
"what takes precedence- ALTER SYSTEM, or a configuration in
Greetings,
* Thomas Kellerer (spam_ea...@gmx.net) wrote:
> Stephen Frost schrieb am 06.12.2018 um 15:52:
> > The regular postgresql.conf file is read first, then
> > postgresql.auto.conf and then pg_hba.conf and pg_ident.conf. We can't
> > read pg_hba.conf/pg
Greetings Chuck,
* Chuck Martin (clmar...@theombudsman.com) wrote:
> Using iperf, the transfer speed between the two servers (from the main to
> the standby) was 938 Mbits/sec. If I understand the units correctly, it is
> close to what it can be.
That does look like the rate it should be going at
Greetings,
* Siegfried Bilstein (sbilst...@gmail.com) wrote:
> I'm evaluating using a tool called Postgraphile that generates a GraphSQL
> server from a postgres setup. The recommended way of handling security is
> to implement RLS within postgres and simply have the webserver take a
> cookie or s
Greetings,
* Thiemo Kellner (thi...@gelassene-pferde.biz) wrote:
> I posted a question and did not get a reaction. Now I wonder whether no one
> took interest (no offence meant) no one has an answer or whether the point
> in time I posted was just rubbish. In the latter case I would be inclined to
Greetings,
* Hilbert, Karin (i...@psu.edu) wrote:
> Does anyone manage a PostgreSQL database for a GITLAB application?
Yes.
> I have PostgreSQL v9.6 installed on my server & we are trying to migrate a
> GITLAB database there.
>
> The developer says that we need to use the public schema instead
Greetings,
* Hilbert, Karin (i...@psu.edu) wrote:
> The other year, we had to restore the prod database backup to dev & that
> changed the schema name. I was thinking that it would be better have the
> same names used for dev & prod so that restores from one environment to
> another would be e
Greetings,
Hopefully everyone realizes this but just to be clear- the below
(truncated) was spam and has been hidden from the archives. Apologies
for it getting through, we'll look into what we can do to avoid having
it happen again in the future...
Please do *not* click the link that was in tha
Greetings,
* Alex Morris (alex.mor...@twelvemountain.com) wrote:
> This question may simply be my ignorance of what piece of the systemd /
> systemctl puzzle needs attention. Any clues are appreciated.
The simplest approach is to just modify the postgresql.conf file in
/etc/postgresql/9.5/main t
Greetings,
* Ron (ronljohnso...@gmail.com) wrote:
> The backups partition is running out of disk space, and I need to delete the
> only backup.
>
> $ pgbackrest expire --stanza=localhost --retention-full=0
> ERROR: [032]: '0' is out of range for 'repo1-retention-full' option
Yeah, pgbackrest doe
Greetings,
* Ron (ronljohnso...@gmail.com) wrote:
> On 1/24/19 7:26 AM, Stephen Frost wrote:
> >* Ron (ronljohnso...@gmail.com) wrote:
> >>The backups partition is running out of disk space, and I need to delete the
> >>only backup.
> >>
> >>$ pgbackre
Greetings,
* Ron (ronljohnso...@gmail.com) wrote:
> On 1/24/19 8:11 AM, Stephen Frost wrote:
> >* Ron (ronljohnso...@gmail.com) wrote:
> >>On 1/24/19 7:26 AM, Stephen Frost wrote:
> >>>* Ron (ronljohnso...@gmail.com) wrote:
> >>>>The backups partitio
Greetings,
* Arjun Ranade (ran...@nodalexchange.com) wrote:
> Yeah, that was one thing I was planning to try. The other potential
> solution is to use barman (we are using barman on all db servers including
> standbys) to restore the latest backup to a VM and then take the pg_dump
> from there.
Greetings,
* Arjun Ranade (ran...@nodalexchange.com) wrote:
> Will barman automatically do a delta restore assuming the postgres server
> is stopped and the old cluster exists at the same location it's restoring
> to?
I don't know if barman supports that today, it might. I do know that
pgbackres
Greetings,
* Martín Fernández (fmarti...@gmail.com) wrote:
> After reading the pg_upgrade documentation multiple times, it seems that
> after running pg_upgrade on the primary instance, we can't start it until we
> run rsync from the primary to the standby. I'm understanding this from the
> fol
Greetings,
* Hellmuth Vargas (hiv...@gmail.com) wrote:
> But could you do the following procedure?:
> pg_upgrade of the master
> rysnc with a hot standby
The above should be alright provided both the primary and the standby
are down and the instructions in the pg_upgrade docs are followed.
> ar
Greetings,
* Martín Fernández (fmarti...@gmail.com) wrote:
> Thanks for information! I've refactor our migration scripts to follow the
> suggestions.
Please don't top-post on these mailing lists.
> One extra question that popped up. As long as we don't start the standby
> (after running rsync
Greetings,
* Martín Fernández (fmarti...@gmail.com) wrote:
> On Tue, Feb 19, 2019 at 1:37 PM Stephen Frost wrote:
> > * Martín Fernández (fmarti...@gmail.com) wrote:
> > > Thanks for information! I've refactor our migration scripts to follow
> > the suggestions.
>
Greetings,
* Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote:
> No backup solution (no matter which one you choose) is 100% guaranteed: your
> disks may fail, your network mail fail, your memory may fail, files get
> corrupted - so, setup a regular "restore" to separate "test backup
Greetings,
* Bruce Momjian (br...@momjian.us) wrote:
> On Tue, Feb 19, 2019 at 12:25:24PM -0500, Stephen Frost wrote:
> > Ah, right, I forgot that it did that, fair enough.
> >
> > I've never been thrilled with that particular approach due to the
> > inherent
Greetings,
* Zachary Hanson-Hart (zac...@temple.edu) wrote:
>I know that the requirement for replication is that a user be allowed to
> connect to the "replication" database. My question is how to configure the
> streaming replication client to use a particular authentication method. I
> hav
Greetings,
* Filip Rembiałkowski (filip.rembialkow...@gmail.com) wrote:
> There is a large (>5T) database on PostgreSQL 9.0.23.
First off, I hope you understand that 9.0 has been *long* out of
support and that you *really* need to upgrade to a supported version of
PostgreSQL (9.4 and up these day
Greetings Mike,
* Mike Yeap (wkk1...@gmail.com) wrote:
> Hi Thomas, I see. guess I can't use LDAP authentication for now, :-(
If you're in an active directory environment, you should really be using
Kerberos for authentication and NOT LDAP anyway. LDAP-based
authentication involves sending t
Greetings,
* Julie Nishimura (juliez...@hotmail.com) wrote:
> Hello everybody, I am new to postgresql environment, but trying to get up to
> speed.
> Can you please share your experience on how you can automate refreshment of
> dev environment on regular basis (desirably weekly), taking for cons
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> I'm trying to configure authentication between PostgreSQL database server on
> linux and Windows Active Directory.
>
> First part of configuration is working but when I'm trying to authenticate
> from Windows client, it is not worki
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> Thank you very much for your help.
> I think I was missing an important command in the equation.
>
> sudo realm --verbose join ad.corp.com --user=Administrateur
> --user-principal=postgres/ubuntu.ad.corp@ad.corp.com
>
> The Li
Greetings,
* Martín Fernández (fmarti...@gmail.com) wrote:
> I've wrote a couple of questions around pg_upgrade and updating standbys
> using rsync last week. We were able to successfully upgrade half of our
> cluster (the other half was kept for failover) from pg92 with postgis 1.5.8
> to pg10
Greetings,
* Michael Lewis (mle...@entrata.com) wrote:
> > Is there a way to tell Postgres “please don’t use index X when queries
> > that could use index Y instead occur?”
>
> No. But you could re-write the query to make the date index useless. The
> simplest way that comes to mind is putting th
Greetings,
* Michael Lewis (mle...@entrata.com) wrote:
> Thanks for that advance warning since it is a handy option to force the
> planning barrier in my experience. What's a resource to see other coming
> changes in v12 especially changes to default behavior like this? Will there
> be a new cte_c
Greetings,
* Nicholas Magann (nmag...@email.arizona.edu) wrote:
> I'm a student at the University of Arizona. My current course is having us
> pick a product and do a Security Assessment on it. Part of the assessment
> requires us to obtain any authorization necessary before doing the
> assessment
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> I've configured the GSSAPI authentication with MS Active Directory and it
> works very well.
Glad to hear that.
> The problem is that we have a dev and prod environment and each server must
> be configured with gssapi again the dom
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> If I understand, the mapping can be done in the pg_ident.conf file ?
No, you do the mapping in AD.
Look at the '/princ' and '/mapuser' options used in the ktpass command
here:
https://info.crunchydata.com/blog/windows-active-directo
Greetings,
* Jean-Philippe Chenel (jp.che...@live.ca) wrote:
> You're absolutely right, the mapping work very well.
Great, glad to hear it.
> I've created 2 "service user" on Active Directory (postgres and
> postgres_dev), and generated the keytab like this:
>
> ktpass -out postgres_pg1.keytab
Greetings,
* Charlin Barak (charlinba...@gmail.com) wrote:
> When migrating from Oracle number(10,3) to PostgreSQL, is numeric(10,3)
> ideal or should I consider some other data types?
This really depends on what data is actually in that field and if you
need it to be exact.
If the field actuall
Greetings,
(Dropping all the extra mailing lists and such, please do *not*
cross-post like that)
* M Tarkeshwar Rao (m.tarkeshwar@ericsson.com) wrote:
> We want to setup ldap authentication in pg_hba.conf, for Postgresql
> users(other than postgres super user).
>
> We are getting issue wi
Greetings,
* Rich Shepard (rshep...@appl-ecosys.com) wrote:
> That's why I thought of copying the entire data/ directory.
That isn't going to work because things change in the data directory...
> >Also, I don't know what method you've been using to make file-level
> >backups, but they're really
Greetings,
* David G. Johnston (david.g.johns...@gmail.com) wrote:
> On Thu, May 16, 2019 at 8:31 AM Daulat Ram
> wrote:
>
> > url_hash| bigint | | not null |
>
> Change the type of url_hash; make it text instead of bigint.
Making it text wastes a bunch of sp
Greetings,
* Peter J. Holzer (hjp-pg...@hjp.at) wrote:
> On 2019-05-18 19:16:19 -0500, Ron wrote:
> > > If the the table fills up, you increase nr_buckets, reallocate and
> > > rehash all entries.
> >
> > Ouch. Response time on a big table would take a serious hit if that rehash
> > happened in
Greetings,
* PALAYRET Jacques (jacques.palay...@meteo.fr) wrote:
> If, for security reasons, I can't create a connection or a flow from
> subscriber/secundary/slave towards provider/primary/master, witch replication
> systems can I use ?
The simplest approach might be to use WAL shipping with
Greetings,
(dropping -admin, please do NOT send to multiple mailing lists- just
pick one)
* Pavan Kumar (pavan.db...@gmail.com) wrote:
> Is it possible to configure multiple backup repositories in pgbackrest tool
> in one server?
While we have considered adding support for that, it's not there t
Greetings,
* Ravi Krishna (ravikris...@mail.com) wrote:
> On 6/14/19 10:01 AM, Tiemen Ruiten wrote:
> >LOG: checkpoint starting: immediate force wait
>
> Does it mean that the DB is blocked until the completion of checkpoint.
> Years ago
> Informix use to have this issue until they fixed around
Greetings,
* Tiemen Ruiten (t.rui...@tech-lab.io) wrote:
> checkpoint_timeout = 60min
That seems like a pretty long timeout.
> My problem is that checkpoints are taking a long time. Even when I run a
> few manual checkpoints one after the other, they keep taking very long, up
> to 10 minutes:
Y
Greetings,
* Tiemen Ruiten (t.rui...@tech-lab.io) wrote:
> On Fri, Jun 14, 2019 at 5:43 PM Stephen Frost wrote:
> > * Tiemen Ruiten (t.rui...@tech-lab.io) wrote:
> > > checkpoint_timeout = 60min
> >
> > That seems like a pretty long timeout.
>
> My reasonin
Greetings,
* Jeff Janes (jeff.ja...@gmail.com) wrote:
> On Sat, Jun 15, 2019 at 4:50 AM Tiemen Ruiten wrote:
> > On Fri, Jun 14, 2019 at 5:43 PM Stephen Frost wrote:
> >> The time information is all there and it tells you what it's doing and
> >> how much had
Greetings,
* Tiemen Ruiten (t.rui...@tech-lab.io) wrote:
> On Sun, Jun 16, 2019 at 8:57 PM Alvaro Herrera
> wrote:
> > Note that Joyent ended up proposing patches to fix their performance
> > problem (and got them committed). Maybe it would be useful for Tiemen
> > to try that code? (That commi
Greetings,
* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
> On 2019-Jun-16, Stephen Frost wrote:
> > Not likely to help with what you're experiencing anyway though...
>
> My gut feeling is that you're wrong, since (as I understand) the
> symptoms are the same.
Greetings,
* Tiemen Ruiten (t.rui...@tech-lab.io) wrote:
> On Sun, Jun 16, 2019 at 7:30 PM Stephen Frost wrote:
> > Ok, so you want fewer checkpoints because you expect to failover to a
> > replica rather than recover the primary on a failure. If you're doing
> > syn
Greetings,
* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
> On 2019-Jun-16, Stephen Frost wrote:
>
> > The issue being discussed here is writing out to the heap files during a
> > checkpoint...
>
> We don't really know, as it was already established that the
Greetings,
* Nathaniel Sabanski (sabansk...@gmail.com) wrote:
> HN had a thread regarding the challenges faced by new users during the
> adoption of Postgres in 2023.
>
> One particular issue that garnered significant votes was the lack of a
> "SHOW CREATE TABLE" command, and seems like it would
Greetings,
Please don't top-post on these lists.
* Nathaniel Sabanski (sabansk...@gmail.com) wrote:
> I believe most users would anticipate a CREATE TABLE statement that aligns
> with the currently installed version- this is the practical solution for
> the vast majority.
Perhaps a bit more disc
Greetings,
* Nathaniel Sabanski (sabansk...@gmail.com) wrote:
> > Perhaps a bit more discussion about what exactly the use-case is would
> > be helpful- what would you use this feature for?
>
> App writers: To facilitate table creation and simplify schema verification,
> without relying on a GUI
Greetings,
* Tom Lane (t...@sss.pgh.pa.us) wrote:
> Stephen Frost writes:
> > Again, would be great to see someone actually work on this. There's
> > already a good chunk of code in core in pg_dump and in the postgres_fdw
> > for doing exactly this and it'd be g
Greetings,
* Kirk Wolak (wol...@gmail.com) wrote:
> On Fri, May 12, 2023 at 4:37 PM Stephen Frost wrote:
> > * Tom Lane (t...@sss.pgh.pa.us) wrote:
> > > Stephen Frost writes:
> > > > Again, would be great to see someone actually work on this. There's
>
Greetings,
* Tony Xu (tony...@rubrik.com) wrote:
> The FAQ (copied below) mentioned that native transparent data encryption
> might be included in 16. Is it fair to assume that it will support database
> level encryption, that is, we can use two encryption keys for two databases
> in the same serv
Greetings,
Please don't top-post on these lists.
* Tony Xu (tony...@rubrik.com) wrote:
> Our use-case is for a multi-tenancy scenario - we are considering using
> different databases to store different customer's data, however, for
> cost-efficiency, we want to host them in the same server (to re
Greetings,
Really, please don't top-post on these lists.
* Tony Xu (tony...@rubrik.com) wrote:
> Regarding the multiple clusters idea, how does that work? Assume we can
> store one customer's data in one cluster, is it possible to have separate
> KEK for different clusters?
In the proposed TDE w
Greetings,
There seems to be a bit of confusion here, so I'll try to clear it up.
* Tony Xu (tony...@rubrik.com) wrote:
> Thanks all for the discussions. It sounds like there are different
> questions to clear before we can get to a conclusion on if per-database KEK
> is possible or not.
It's no
Greetings,
* Lingesan Jeyapandy (lingesan.jeyapa...@gilead.com) wrote:
> We have configured postgres GSSAPI setup on Linux server. We have huge
> domain AD users in our org.
>
> But we are looking to limit access only to setup AD distributed groups. Is
> there any way to control access only a
Greetings,
* Abhishek Bhola (abhishek.bh...@japannext.co.jp) wrote:
> I recently set up a Postgres15 master-slave (Primary-secondary) cluster on
> 2 nodes. At the time of starting, I ensured that data files are exactly the
> same on both the nodes. The size of the DB is 1.5TB.
> The directory stru
Greetings,
* Sabri Taner Burak ALTINDAL (s...@protonmail.com) wrote:
> I am interning at a company. I was using Python to download your mail lists,
> but it seems that there was an unwanted situation, and you have restricted
> access to log in. However, I read that you are not against the storag
Greetings,
* Abhishek Bhola (abhishek.bh...@japannext.co.jp) wrote:
> > Basically, this is not a valid way to perform a backup/restore of PG.
>
> Is it not valid only for PG 15 or even for earlier versions? I have always
> referred to this https://www.postgresql.org/docs/8.1/backup-online.html
F
Greetings,
On Wed, Jul 26, 2023 at 21:31 Abhishek Bhola
wrote:
> Thank you for the very detailed reply. I tried the above method and it
> works. I'm still setting up pgBackRest.
>
> I have one last question if you can answer that too please.
>
>> A delta restore will only restore those
>> files
Greetings,
* Meera Nair (mn...@commvault.com) wrote:
> We are following
> https://www.postgresql.org/docs/14/continuous-archiving.html#BACKUP-LOWLEVEL-BASE-BACKUP
> Making An Exclusive Low-Level Backup.
Exclusive backups have been removed, so you really don't want to be
depending on it.
> After
Greetings,
* Meera Nair (mn...@commvault.com) wrote:
> The backups we ran were all exclusive backups.
You should not use exclusive backups. They've been deprecated for a
long, long time and have been removed in the most recent version of PG.
You really should not be trying to build your own too
Greetings,
* Mario Diangelo (watisdit...@msn.com) wrote:
> We use different Windows servers with Postgresql and looking for the best
> strategy to create daily incremental backups to a (managed) volume. We want
> to achieve this with scripts and run them daily within the TaskSchedular.
> Point
Greetings,
* Emile Amewoto (emil...@yahoo.com) wrote:
> Here is the high level process:
> 1- Create the user x without password in Postgres.
> 2- Assign role or roles to the user x
> 3- Update pg_hba.conf with the ldap connection link.
>
> You might need cert for the ldap to connect to AD, assu
Greetings,
* Ron (ronljohnso...@gmail.com) wrote:
> On 8/21/23 18:49, Bruce Momjian wrote:
> > On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote:
> > > It is mentioned here https://www.postgresql.org/about/press/faq/#:~:text=
> > > Q%3A%20What%20features%20will%20PostgreSQL%2016%20have
Greetings,
* Dominique Devienne (ddevie...@gmail.com) wrote:
> On Thu, Aug 24, 2023 at 10:07 PM Stephen Frost wrote:
> > * Emile Amewoto (emil...@yahoo.com) wrote:
> > > Here is the high level process:
> > > 1- Create the user x without password in Postgres.
> &
Greetings,
* Abhishek Bhola (abhishek.bh...@japannext.co.jp) wrote:
> I am trying to use pgBackRest for all my Postgres servers. I have tested it
> on a sample database and it works fine. But my concern is for some of the
> bigger DB clusters, the largest one being 50TB and growing by about
> 200-
Greetings,
* Ron (ronljohnso...@gmail.com) wrote:
> On 8/24/23 14:08, Stephen Frost wrote:
> > * Ron (ronljohnso...@gmail.com) wrote:
> > > On 8/21/23 18:49, Bruce Momjian wrote:
> > > > On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote:
> > > &g
Greetings,
* Matthias Apitz (g...@unixarea.de) wrote:
> message from Stephen Frost mailto:sfr...@snowman.net>
> > * Ron (ronljohnso...@gmail.com <mailto:ronljohnso...@gmail.com>) wrote:
> > > On 8/21/23 18:49, Bruce Momjian wrote:
> > > > On Mon, Aug 21,
Greetings,
On Mon, Oct 2, 2023 at 20:08 Abhishek Bhola
wrote:
> As said above, I tested pgBackRest on my bigger DB and here are the
> results.
> Server on which this is running has the following config:
> Architecture: x86_64
> CPU op-mode(s):32-bit, 64-bit
> Byte Order:
Greetings,
On Thu, Oct 5, 2023 at 03:10 Abhishek Bhola
wrote:
> Here is the update with compress-type=zst in the config file
> Process-max is still 30. *But it longer than before, around 27 hours 50
> mins*
>
> full backup: 20231004-130621F
> timestamp start/stop: 2023-10-04 13:06:21
Greetings,
* Abdul Qoyyuum (aqoyy...@cardaccess.com.bn) wrote:
> Knowing that it's a data corruption issue, the only way to fix this is to
> vacuum and reindex the database. What was suggested was the following:
>
> SET zero_damaged_pages = 0; # This is so that we can have the application
> to co
Greetings,
On Thu, Nov 30, 2023 at 02:51 Abdul Qoyyuum
wrote:
> On Wed, Nov 29, 2023 at 5:53 PM Stephen Frost wrote:
>
>> * Abdul Qoyyuum (aqoyy...@cardaccess.com.bn) wrote:
>> > Knowing that it's a data corruption issue, the only way to fix this is
>> to
>
201 - 300 of 399 matches
Mail list logo
