On Sat, Aug 28, 2021 at 04:08:33PM +0800, Sudhir Guna wrote:
> The RHEL upgrade from 7.5 to 8.4 is not done as an incremental version
> upgrade rather directly from 7.5.
I think the process should be:
1) upgrade from RH7 to RH8;
2) reindex relevant indexes (see wiki link below);
3) upgrade from p
Hi,
Amazon Linux is not compatible with RHEL the way CentOS is and it's not a
supported platform for the RPM installation:
https://www.pgadmin.org/download/pgadmin-4-rpm/
The repo configuration probably uses some variables to create the download
URLs and because the versions don't match, it resul
hubert depesz lubaczewski writes:
> On Fri, Aug 27, 2021 at 05:23:23PM -0400, Tom Lane wrote:
>> Those queries are coming from getFormattedTypeName(), which is used
>> for function arguments and the like. I'm not quite sure why Hubert
>> is seeing 5000 such calls in a database with only ~100 func
On 8/27/21 5:31 PM, Gilar Ginanjar wrote:
Hi, sorry it's been a long time to reply.
It throw the same errors. I can't find any solution. It frustrated me
and i've been on a break since. ;)
Per upstream advice do something like:
pg_restore -U myuser -s -d mydb dbdump.backup
to get the schem
On 8/27/21 3:50 PM, ourdiaspora wrote:
‐‐‐ Original Message ‐‐‐
On Friday, August 27th, 2021 at 11:10 PM, Adrian Klaver
wrote:
https://www.php.net/manual/en/pdo.pgsqlcopyfromfile.php
"
public PDO::pgsqlCopyFromFile(
string $table_name,
string $filename,
"
Sorry but do
On 2021-08-28 09:52:45 -0700, Adrian Klaver wrote:
> On 8/27/21 3:50 PM, ourdiaspora wrote:
> > On Friday, August 27th, 2021 at 11:10 PM, Adrian Klaver
> > wrote:
> >
> > > https://www.php.net/manual/en/pdo.pgsqlcopyfromfile.php
> > >
> >
> > "
> > public PDO::pgsqlCopyFromFile(
> > strin
On Saturday, August 28th, 2021 at 5:52 PM, Adrian Klaver
wrote:
>
> You are asking the user to select a file, so there should be some sort
>
> of file reference at that point, correct?
>
This is what causes confusion. If a user has a file named 'mydatafile.csv', why
does the manual make refe
On Fri, Aug 27, 2021 at 2:59 PM ourdiaspora
wrote:
> Please what is the syntax to assign an unknown file name to the 'fopen'
> function?
>
>
There isn't one as it would make no sense - how is it supposed to open a
file if there is no filename provided to open?
You have to set things up yourself
Here is a second patch, quite independent of the first one, that
gets rid of some other repetitive queries. On the regression database,
the number of queries needed to do "pg_dump -s regression" drops from
3260 to 2589, and on my machine it takes 1.8 sec instead of 2.1 sec.
What's attacked here i
On 8/28/21 2:55 PM, ourdiaspora wrote:
On Saturday, August 28th, 2021 at 5:52 PM, Adrian Klaver
wrote:
You are asking the user to select a file, so there should be some sort
of file reference at that point, correct?
This is what causes confusion. If a user has a file named 'mydatafile.c
Hi all,
I am facing an issue.
when I run a script:
INSERT INTO mdm.etl_exception_info
SELECT
*
FROM mdm.etl_exception_info_vw2;
after running script I check this script in pg_lock, everything ok, job
done, data is inserted. However, the session contains the script above
doesn't complete t
On Saturday, August 28, 2021, Trang Le wrote:
>
> after running script
>
>
How?
>
> I check this script in pg_lock, everything ok, job
> done, data is inserted.
>
>
You can tell this from pg_lock?
>
>
> However, the session
>
>
Where is this session?
David J.
On 8/28/21 11:40 PM, Trang Le wrote:
Hi all,
I am facing an issue
when I run a script:
INSERT INTO mdm.etl_exception_info
SELECT
*
FROM mdm.etl_exception_info_vw2;
Is there any error message thrown? If there is, can you tell us? Is
autocommit on? What does the log say?
after runn
13 matches
Mail list logo
