Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhnpP-00DRg9-OX for pgsql-admin@arkaria.postgresql.org; Wed, 06 Mar 2024 09:44:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rhnpO-007r5k-4k for pgsql-admin@arkaria.postgresql.org; Wed, 06 Mar 2024 09:44:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhnpN-007r5c-M5 for pgsql-admin@lists.postgresql.org; Wed, 06 Mar 2024 09:44:46 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhnpK-0037Gr-1v for pgsql-admin@lists.postgresql.org; Wed, 06 Mar 2024 09:44:44 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 72DAD3802ED; Wed, 6 Mar 2024 10:44:40 +0100 (CET) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id JSt6e4RNpw5l; Wed, 6 Mar 2024 10:44:40 +0100 (CET) Received: from [192.168.178.86] (xdsl-212-8-147-90.nc.de [212.8.147.90]) by rs.plausibolo.de (Postfix) with ESMTPSA id 19B99380176; Wed, 6 Mar 2024 10:44:40 +0100 (CET) Message-ID: <4fbd9687-7e3e-188e-a030-47977e6e3563@jakobs.com> Date: Wed, 6 Mar 2024 10:44:39 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: Equivalent of Oracle Advanced Queue in Postgres Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------Z9Uszw0hL1lVPK014P2Lzy7Q" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------Z9Uszw0hL1lVPK014P2Lzy7Q Content-Type: multipart/mixed; boundary="------------SlNiWgHEya6iIGvquLYBoB0f"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <4fbd9687-7e3e-188e-a030-47977e6e3563@jakobs.com> Subject: Re: Equivalent of Oracle Advanced Queue in Postgres References: In-Reply-To: --------------SlNiWgHEya6iIGvquLYBoB0f Content-Type: multipart/alternative; boundary="------------9P4EPZle7bsJKvjbKNLaB3DG" --------------9P4EPZle7bsJKvjbKNLaB3DG Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMDYuMDMuMjQgdW0gMTA6MjIgc2NocmllYiBVbWVzaCBLdW1hciBZYWRhdjoNCj4NCj4g RGVhciBQb3N0Z3JlU1FMIENvbW11bml0eSBGb3J1bSBNZW1iZXJzLA0KPg0KPiBJIGhvcGUg dGhpcyBtZXNzYWdlIGZpbmRzIHlvdSB3ZWxsLiBJIGFtIHJlYWNoaW5nIG91dCB0byBpbnF1 aXJlIGFib3V0IA0KPiB0aGUgZXF1aXZhbGVudCBmdW5jdGlvbmFsaXR5IG9mIE9yYWNsZSBB ZHZhbmNlZCBRdWV1ZSBpbiBQb3N0Z3JlU1FMLg0KPg0KPiBBcyB3ZSBjb250aW51ZSB0byBl eHBsb3JlIGFuZCBtaWdyYXRlIG91ciBkYXRhYmFzZSBzb2x1dGlvbnMgdG8gDQo+IFBvc3Rn cmVTUUwsIHdlIGhhdmUgZW5jb3VudGVyZWQgYSBuZWVkIGZvciBhIGZlYXR1cmUgc2ltaWxh ciB0byBPcmFjbGUgDQo+IEFkdmFuY2VkIFF1ZXVlLiBJbiBPcmFjbGUsIEFkdmFuY2VkIFF1 ZXVlIHByb3ZpZGVzIGEgbWVzc2FnaW5nIA0KPiBpbmZyYXN0cnVjdHVyZSB0aGF0IGVuYWJs ZXMgYXN5bmNocm9ub3VzIGNvbW11bmljYXRpb24gYmV0d2VlbiANCj4gYXBwbGljYXRpb25z LiBJdCBhbGxvd3MgbWVzc2FnZXMgdG8gYmUgc3RvcmVkIHBlcnNpc3RlbnRseSBpbiB0aGUg DQo+IGRhdGFiYXNlIHVudGlsIHRoZXkgYXJlIGNvbnN1bWVkIGJ5IHN1YnNjcmliaW5nIGFw cGxpY2F0aW9ucy4NCj4NCj4gQ291bGQgeW91IHBsZWFzZSBwcm92aWRlIGluc2lnaHRzIG9y IHJlY29tbWVuZGF0aW9ucyBvbiBob3cgd2UgY2FuIA0KPiBhY2hpZXZlIHNpbWlsYXIgZnVu Y3Rpb25hbGl0eSBpbiBQb3N0Z3JlU1FMPyBXZSBhcmUgcGFydGljdWxhcmx5IA0KPiBpbnRl cmVzdGVkIGluIGZlYXR1cmVzIG9yIGV4dGVuc2lvbnMgd2l0aGluIFBvc3RncmVTUUwgdGhh dCBvZmZlciANCj4gcXVldWluZyBjYXBhYmlsaXRpZXMsIG1lc3NhZ2UgcGVyc2lzdGVuY2Us IGFuZCBhc3luY2hyb25vdXMgDQo+IGNvbW11bmljYXRpb24gYmV0d2VlbiBhcHBsaWNhdGlv bnMuDQo+DQo+IEFueSBndWlkYW5jZSwgYmVzdCBwcmFjdGljZXMsIG9yIHN1Z2dlc3Rpb25z IGZyb20gdGhlIGNvbW11bml0eSB3b3VsZCANCj4gYmUgZ3JlYXRseSBhcHByZWNpYXRlZC4g QWRkaXRpb25hbGx5LCBpZiB0aGVyZSBhcmUgYW55IGV4aXN0aW5nIA0KPiBQb3N0Z3JlU1FM IGV4dGVuc2lvbnMgb3IgbW9kdWxlcyB0aGF0IHByb3ZpZGUgY29tcGFyYWJsZSBmdW5jdGlv bmFsaXR5IA0KPiB0byBPcmFjbGUgQWR2YW5jZWQgUXVldWUsIHdlIHdvdWxkIGxvdmUgdG8g bGVhcm4gbW9yZSBhYm91dCB0aGVtLg0KPg0KPiBUaGFuayB5b3UgaW4gYWR2YW5jZSBmb3Ig eW91ciB0aW1lIGFuZCBhc3Npc3RhbmNlLiBXZSBsb29rIGZvcndhcmQgdG8gDQo+IGhlYXJp bmcgZnJvbSB0aGUga25vd2xlZGdlYWJsZSBtZW1iZXJzIG9mIHRoZSBQb3N0Z3JlU1FMIGNv bW11bml0eS4NCj4NCj4gQmVzdCByZWdhcmRzLA0KPg0KPiBVbWVzaCBLdW1hciBZYWRhdg0K Pg0KUGxlYXNlIHRocm93IHRoZSBrZXl3b3JkcyBQb3N0Z3JlU1FMIGFuZCBxdWV1ZSBpbnRv IHlvdXIgZmF2b3VyaXRlIA0Kc2VhcmNoIGVuZ2luZQ0KDQoNCi0tIA0KSG9sZ2VyIEpha29i cywgQmVyZ2lzY2ggR2xhZGJhY2gsIFRlbC4gKzQ5LTE3OC05NzU5MDEyDQoNCg== --------------9P4EPZle7bsJKvjbKNLaB3DG Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Am 06.03.24 um 10:22 schrieb Umesh Kumar Yadav:

Dear PostgreSQL Community Forum Members,

I hope this message finds you well. I am reaching out to inquire about the equivalent functionality of Oracle Advanced Queue in PostgreSQL.

As we continue to explore and migrate our database solutions to PostgreSQL, we have encountered a need for a feature similar to Oracle Advanced Queue. In Oracle, Advanced Queue provides a messaging infrastructure that enables asynchronous communication between applications. It allows messages to be stored persistently in the database until they are consumed by subscribing applications.

Could you please provide insights or recommendations on how we can achieve similar functionality in PostgreSQL? We are particularly interested in features or extensions within PostgreSQL that offer queuing capabilities, message persistence, and asynchronous communication between applications.

Any guidance, best practices, or suggestions from the community would be greatly appreciated. Additionally, if there are any existing PostgreSQL extensions or modules that provide comparable functionality to Oracle Advanced Queue, we would love to learn more about them.

Thank you in advance for your time and assistance. We look forward to hearing from the knowledgeable members of the PostgreSQL community.

Best regards,

Umesh Kumar Yadav

Please throw the keywords PostgreSQL and queue into your favourite search engine


--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------9P4EPZle7bsJKvjbKNLaB3DG-- --------------SlNiWgHEya6iIGvquLYBoB0f-- --------------Z9Uszw0hL1lVPK014P2Lzy7Q Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZeg7BwUDAAAAAAAKCRCKV5yTsxlhuquI AJ45lo8y+m5sv3AQOUxHO/P1yzH6IACfXF0y71XM8BSMDz0ZTb4lYqDSBnM= =Ky/S -----END PGP SIGNATURE----- --------------Z9Uszw0hL1lVPK014P2Lzy7Q--