I believe that's the only way to do it.
On Thu, Sep 5, 2024 at 12:09 PM Muhammad Ikram wrote:
>
> Hi,
>
> I want to change email for my PostgreSQL community subscriptions. Is there
> a way to do it without unsubscribing and then subscribing to a new email ?
>
> --
> Regards,
> Muhammad Ikram
>
>
Hi Chris,
On Wed, Nov 29, 2023 at 7:38 PM Chris Travers
wrote:
>
>
> On Wed, Nov 29, 2023 at 4:36 PM Abdul Qoyyuum
> wrote:
>
>> Hi all,
>>
>> Knowing that it's a data corruption issue, the only way to fix this is to
>> vacuum and reindex the da
Hi Stephen,
On Wed, Nov 29, 2023 at 5:53 PM Stephen Frost wrote:
> 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 s
Hi all,
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 continue to run
VACUUM FULL VERBOSE ANALYSE; # Do a full vacuum and
Apparently just leaving it alone until tomorrow managed to finish
creating/dropping the index. Thank you all very much.
On Thu, Aug 18, 2022 at 5:00 PM hubert depesz lubaczewski
wrote:
> On Thu, Aug 18, 2022 at 01:57:48PM +0800, Abdul Qoyyuum wrote:
> > Hi list,
> >
> > We
when dropping the invalid index, also takes a long time, my connection
timed out, then when logging back in and check the table, it hasn't dropped.
Question is, do we have to shutdown traffic and close all existing open
connections in order to drop and properly recreate the index? Any advice
a
lable, Please share a resource
> from where I can find a proper solution.
>
>
> Thanks and Best Regards,
> Gaurav Daunde
>
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043
redirecting pg_dump output also to E:\, I was taking a tar dump output.
>
> But C:\ is getting filled up . Looks like it is used for some sort of
> temporary staging.
>
> Is there a way not to use C:\ for this?
>
>
>
> Regards,
>
> Meera
>
>
>
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043
o secondary. I can achieve this
> manually using pg_basebackup on primary and pg_restore on secondary. Is
> there any other automated efficient way to achieve the same? Any relevant
> docs would be helpful.
>
> Regards,
> Seenu.
>
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043
Best if you just maintain the logs into a log file instead of a database
table.
On Thu, Jun 16, 2022 at 10:08 PM Rama Krishnan wrote:
> Hi ,
>
> What type of temp database should i use to maintain logs or export logs?
>
> Thanks
> Rama-krishnan
>
--
Abdul Qoyyuum Bin H
nable to resolve /home on the client machine. But maybe
> pgAdmin has its own way to deal with this. Have you read its documentation?
> >
> > I don't know - server is running on the same OSX machine as pgAdmin will
> be.
>
> So nobody is playing with the images?
>
> Is it even possible - to insert an image as BLOB into the database
> using a simple
> INSERT INTO query?
>
> Thank you.
>
> >
> > Thank you.
> >
> > >
> > > David J.
> > >
>
>
>
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043
Thanks Christophe! I guess I had nothing to be worried about.
On Mon, Mar 8, 2021 at 9:46 AM Christophe Pettus wrote:
>
>
> > On Mar 7, 2021, at 17:34, Abdul Qoyyuum
> wrote:
> > Seems to get me worried. Should I be worried? Is this normal? If not,
> what should I do?
seems to suggest its
nothing to worry about but
[u...@db1.pr ~]$ ps -ef | grep postgres | grep idle | wc -l
213
Seems to get me worried. Should I be worried? Is this normal? If not, what
should I do?
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043
> dynamically. Alternatively, I could probably INSERT INTO / UPDATE
> pg_db_role_setting manually?
>
> Any other ideas how to achieve this easily? Does the proposed "IN
> CURRENT DATABASE" syntax sound useful to anyone else?
>
> Best,
>
> Wolfgang
>
>
>
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043
et to ALTER the database and log_statement
changed to 'ddl' for specific databases but somehow doesn't work. Hence the
short and small manual test to see.
Abdul Qoyyuum Bin Haji Abdul Kadir
System Engineer at Card Access Services
HP: +673 720 8043
On Tue, 16 Feb 2021, 11:23 David G. J
21682]: [3602-1] etx_ecom>
LOG: statement: INSERT into card_type VALUES('Q','TEST');
Why doesn't the Alter Database work?
--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043
16 matches
Mail list logo
