g_snapshots pg_stat_tmp
pg_tblspcpg_wal
[edb@localhost bin]$
Kashif Zeeshan
EnterpriseDB
On Thu, Apr 2, 2020 at 2:58 PM Rajkumar Raghuwanshi <
rajkumar.raghuwan...@enterprisedb.com> wrote:
> Hi Asif,
>
> My colleague Kashif Zeeshan reported an issue off-list, posting here,
>
On Thu, Apr 2, 2020 at 4:48 PM Robert Haas wrote:
> On Thu, Apr 2, 2020 at 7:30 AM Kashif Zeeshan <
> kashif.zees...@enterprisedb.com> wrote:
>
>> The backup failed with errors "error: could not connect to server: could
>> not look up local user ID 100
On Thu, Apr 2, 2020 at 6:23 PM Robert Haas wrote:
> On Thu, Apr 2, 2020 at 7:55 AM Kashif Zeeshan
> wrote:
> > Thanks alot Robert,
> > In this case the backup folder was not being emptied as the backup was
> failed, the cleanup should be done in this case too.
>
> D
t the overall bytes
> that
> have been transferred. So the workers would sleep if they have exceeded the
> limit. Hence, the shared state carries a lock to safely update the
> throttling
> value atomically.
>
> Progress Reporting:
> Although I think we should add progress-reporting for parallel backup as a
> separate patch. The relevant entries for progress-reporting such as
> ‘backup_total’ and ‘backup_streamed’ would be then added to this structure
> as well.
>
>
> Grammar:
> There is a change in the resultset being returned for START_BACKUP
> command;
> unique_backup_id is added. Additionally, JOIN_BACKUP replication command is
> added. SEND_FILES has been renamed to SEND_FILE. There are no other changes
> to the grammar.
>
> START_BACKUP [LABEL ''] [FAST]
> - returns startptr, tli, backup_label, unique_backup_id
> STOP_BACKUP [NOWAIT]
> - returns startptr, tli, backup_label
> JOIN_BACKUP ‘unique_backup_id’
> - attaches a shared state identified by ‘unique_backup_id’ to a backend
> process.
>
> LIST_TABLESPACES [PROGRESS]
> LIST_FILES [TABLESPACE]
> LIST_WAL_FILES [START_WAL_LOCATION 'X/X'] [END_WAL_LOCATION 'X/X']
> SEND_FILE '(' FILE ')' [NOVERIFY_CHECKSUMS]
>
>
> --
> Asif Rehman
> Highgo Software (Canada/China/Pakistan)
> URL : www.highgo.ca
>
>
--
Regards
Kashif Zeeshan
Lead Quality Assurance Engineer / Manager
EnterpriseDB Corporation
The Enterprise Postgres Company
Getting the same issue at my end, the error message is "The URL you
specified does not exist.".
On Tue, Jun 11, 2024 at 12:33 AM Mark Hill wrote:
> Is there an issue with the ODBC Source downloads today?
>
> The source download URL isn’t working:
> https://www.postgresql.org/ftp/odbc/versions/sr
On Tue, Jun 11, 2024 at 4:52 PM Fahar Abbas
wrote:
> Hello Mark,
>
> You can found psqlodbc on Link below
>
> https://www.postgresql.org/ftp/odbc/releases/REL-16_00_0005/
>
> He is talking about Source code whereas this link contains installer.
Regards
Kashif Zeeshan
B
Hi
Its always a good idea to extend the functionality of PG.
Thanks
Kashif Zeeshan
On Mon, Jun 24, 2024 at 5:57 AM Gurjeet Singh wrote:
> Is there a desire to have a division operator / that takes dividend
> and divisor of types interval, and results in a quotient of type
> double
Hi Tom
There is alot of stuff available online, you just need to find it, also the
Official PG documentation is extensive too..
Regards
Kashif Zeeshan
On Tue, Jun 25, 2024 at 7:04 PM Tom Browder wrote:
> I’m a complete novice, although I’ve dipped my toes in Admin waters a
> couple of
On Thu, Jun 27, 2024 at 2:06 PM wrote:
> Hi,
>
> pg_stat_io has I/O statistics that are collected when track_io_timing is
> enabled, but it is not mentioned in the description of track_io_timing.
> I think it's better to add a description of pg_stat_io for easy reference.
> What do you think?
>
I
Hi
I think the documentation should be updated and all pre-reqs must be added.
Regards
Kashif Zeeshan
On Thu, Jul 4, 2024 at 11:02 PM Said Assemlal wrote:
> Hi,
>
>
> I just built postgresql on macos sonoma (v14) and I had to install the
> following packages:
>
&g
ctory remains unchanged — minor upgrades are that simple.*
Please follow the links below for more information.
https://www.postgresql.org/docs/13/upgrading.html
https://www.postgresql.org/support/versioning/
Thanks
Kashif Zeeshan
Bitnine Global
On Thu, Apr 25, 2024 at 9:37 PM •Isaac Rv wrote:
&g
ta
2. Review the release notes of the update release
3. Stop the PG Server
4. Upgrade postgres to newer version, e.g. on CentOS use the command 'sudo
yum update postgresql'
5. Restart PG Server
Thanks
Kashif Zeeshan
Bitnine Global
>
> El jue, 25 abr 2024 a las 11:20, Kashif Zeeshan
st package update, try clearing
the cache and rebuilding it
yum clean all
yum makecache
>
> El jue, 25 abr 2024 a las 23:16, Kashif Zeeshan ()
> escribió:
>
>>
>>
>> On Thu, Apr 25, 2024 at 11:55 PM •Isaac Rv
>> wrote:
>>
>>> Entiendo si, me
Congratulations!
On Sat, Apr 27, 2024 at 11:34 AM Andrey M. Borodin
wrote:
>
>
> > On 26 Apr 2024, at 16:54, Jonathan S. Katz wrote:
> >
> > The Core Team would like to extend our congratulations to Melanie
> Plageman and Richard Guo, who have accepted invitations to become our
> newest Postgre
Glad to be of help.
pg_uprade is used with major version upgrade e.g. from PG13 to 14 etc
Regards
Kashif Zeeshan
Bitnine Global
On Fri, Apr 26, 2024 at 10:47 PM •Isaac Rv wrote:
> Hola, lo acabo de hacer, quedó bien luego detuve el servidor, aplique otra
> vez el sudo yum update postgr
Hi
You can also use the following approaches.
1. Cursors
2. FETCH with OFFSET clause
Regards
Kashif Zeeshan
Bitnine Global
On Sat, Apr 27, 2024 at 12:47 PM Sushrut Shivaswamy <
sushrut.shivasw...@gmail.com> wrote:
> Hey,
>
> I"m trying to read the rows of a table in chunk
Looks good.
On Mon, Apr 29, 2024 at 12:05 PM Peter Eisentraut
wrote:
> I found two mistakes related to collation and/or ICU support in the
> documentation that should probably be fixed and backpatched. See
> attached patches.
upgrade your
existing installation.
Regards
Kashif Zeeshan
Bitnine Global
>
> El sáb, 27 abr 2024 a las 9:29, Kashif Zeeshan ()
> escribió:
>
>> Glad to be of help.
>> pg_uprade is used with major version upgrade e.g. from PG13 to 14 etc
>>
>> Regards
>> Kashif
d.
>
> I do plan to remove the entity reference and place the content into
> query.sgml directly in the final version. It is just much easier to write
> an entire new section in its own file.
>
Reviewed the documentation update and it's quite extensive, but I think
it's bet
Hi David
I reviewed the documentation and it's very detailed.
Thanks
Kashif Zeeshan
Bitnine Global
On Thu, May 2, 2024 at 8:24 PM David G. Johnston
wrote:
> On Wed, May 1, 2024 at 9:47 PM Tom Lane wrote:
>
>> David Rowley writes:
>> > Let's bash it into sh
/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
But you done need to disable it as this will disable the repo you installed
above.
sudo dnf -qy module disables postgresql
Regards
Kashif Zeeshan
Bitnine Global
On Fri, May 3, 2024 at 7:28 PM •Isaac Rv wrote:
> Hola, estos son los pasos que me dan
conf: Permission denied
>
> rajanx@b0be835adb74 postgresql % su cat
>> /usr/local/pgsql/data/postgresql.auto.conf
>> Password:
>> su: Sorry
>>
>
The issue is related with permissions, please make sure which user did the
installation and update the postgresql.auto.conf file with that user
permissions.
Regards
Kashif Zeeshan
Bitnine Global
>
> Please help! Thank you. :)
> --
> Regards
> Rajan Pandey
>
Hi Jonathan
Did the review and did not find any issues.
Regards
Kashif Zeeshan
Bitnine Global
On Thu, May 16, 2024 at 6:45 AM Jonathan S. Katz
wrote:
> Hi,
>
> Attached is a copy of the PostgreSQL 17 Beta 1 release announcement
> draft. This contains a user-facing summary of
Great initiative.
On Thu, May 16, 2024 at 10:59 AM Andrey M. Borodin
wrote:
> Hi hackers!
>
> StHighload conference will be held on June 24-25[0]. I’m planning to do
> “Pre-Commitfest Party” there.
>
> The idea is to help promote patches among potential reviewers. And start
> working with the ve
sing the following command
select pg_terminate_backend(pid of bgworker);
Regards
Kashif Zeeshan
Bitnine Global
>
> worker.bgw_flags = BGWORKER_SHMEM_ACCESS;
>
> worker.bgw_start_time = BgWorkerStart_PostmasterStart;
>
>
>
> I want to switch off the worker based on some flag
Hi Jian
On Mon, Jun 3, 2024 at 9:14 AM jian he wrote:
> hi.
>
> setup
> drop table if exist test__int cascade;
> create extension intarray;
>
> CREATE TABLE test__int( a int[] );
> CREATE INDEX text_idx on test__int using gist (a gist__intbig_ops(siglen =
> 1));
> drop extension intarray ca
On Fri, Apr 3, 2020 at 3:01 PM Kashif Zeeshan <
kashif.zees...@enterprisedb.com> wrote:
> Hi Asif
>
> When a non-existent slot is used with tablespace then correct error is
> displayed but then the backup folder is not cleaned and leaves a corrupt
> backup.
>
> Steps
@localhost bin]$
[edb@localhost bin]$
[edb@localhost bin]$ ls /home/edb/Desktop/backup
base pg_hba.confpg_logicalpg_notifypg_serial
pg_stat pg_subtrans pg_twophase pg_xact postgresql.conf
pg_dynshmem pg_ident.conf pg_multixact pg_replslot pg_snapshots
pg_
file
"base/pgsql_tmp/pgsql_tmp_b4ef5ac0fd150b2a28caf626bbb1bef2.1": No such file
or directory
pg_basebackup: removing contents of data directory
"/home/edb/Desktop/backup/"
[edb@localhost bin]$
Thanks
On Tue, Apr 14, 2020 at 5:33 PM Asif Rehman wrote:
>
>
> On Wed, Apr
On Tue, Apr 14, 2020 at 7:37 PM Asif Rehman wrote:
>
>
> On Tue, Apr 14, 2020 at 6:32 PM Kashif Zeeshan <
> kashif.zees...@enterprisedb.com> wrote:
>
>> Hi Asif
>>
>> Getting the following error on Parallel backup when --no-manifest option
>> is used.
On Tue, Apr 14, 2020 at 5:33 PM Asif Rehman wrote:
>
>
> On Wed, Apr 8, 2020 at 6:53 PM Kashif Zeeshan <
> kashif.zees...@enterprisedb.com> wrote:
>
>>
>>
>> On Tue, Apr 7, 2020 at 9:44 PM Asif Rehman
>> wrote:
>>
>>> Hi,
>>&
On Wed, Jan 8, 2025 at 3:21 AM Jacob Champion <
jacob.champ...@enterprisedb.com> wrote:
> On Fri, Dec 20, 2024 at 2:21 PM Daniel Gustafsson wrote:
> >
> > > On 20 Dec 2024, at 02:00, Jacob Champion <
> jacob.champ...@enterprisedb.com> wrote:
> >
> > Thanks for the new version, I was doing a v39 r
On Tue, Jan 14, 2025 at 6:00 AM Jacob Champion <
jacob.champ...@enterprisedb.com> wrote:
> On Mon, Jan 13, 2025 at 3:21 PM Jacob Champion
> wrote:
> > Next email will discuss the architectural bug that Kashif found.
>
> Okay, here goes. A standard OAuth connection attempt looks like this
> (oh, I
Congrats Jacob.
On Mon, Apr 14, 2025 at 8:32 AM Ashutosh Bapat
wrote:
> Hearty congratulations Jacob.
>
> On Mon, Apr 14, 2025 at 6:55 AM Richard Guo
> wrote:
> >
> > On Sat, Apr 12, 2025 at 5:26 AM Jonathan S. Katz
> wrote:
> > > The Core Team would like to extend our congratulations to Jacob
34 matches
Mail list logo
