Hi,
a currency rate can have no company, and is then applicable to currencies
which have no rate specific for the company.
Le dim. 10 juin 2018 à 17:24, Adrian Klaver a
écrit :
> On 06/05/2018 07:58 AM, Nicolas Seinlet wrote:
> > Hi,
> >
> > I've tried some tests, by generating various datas in
>> Is this the regular Postgres log or the pg_upgrade log which should be
something like pg_upgrade_server.log?
This is the pg_upgrade_dump_16400.log.
>> How did you get into the 10 cluster to report on the database OID's and
names?
After the pg_upgrade failed I was able to start both clusters
On Mon, Jun 11, 2018 at 10:12 AM, a <372660...@qq.com> wrote:
> Hey, the following is the table :
> 1 1 1 "f" 1 "2018-06-11 11:38:33.163731+08" "00:00:00.033002" "Couldn't
> get a connection to the database!"
> 2 2 1 "f" 1 "2018-06-11 11:45:03.406061+08" "00:00:00.033002" "Couldn't
> get a connect
Hey, the following is the table :
1 1 1 "f" 1 "2018-06-11 11:38:33.163731+08"
"00:00:00.033002" "Couldn't get a connection to the database!"
2 2 1 "f" 1 "2018-06-11 11:45:03.406061+08"
"00:00:00.033002" "Couldn't get a connection
On Mon, Jun 11, 2018 at 9:56 AM, a <372660...@qq.com> wrote:
> Hey thanks so much.
>
> I found the error msg as "Couldn't get a connection to the database!"
>
> I've searched internet with the issue, some may say replace pgpass.conf as
> follow:
>
> "*localhost:5432:[dbname]:postgres:[password]*"
Hey thanks so much.
I found the error msg as "Couldn't get a connection to the database!"
I've searched internet with the issue, some may say replace pgpass.conf as
follow:
"localhost:5432:[dbname]:postgres:[password]"
but after I changed, the job returns a "i" as last result, which is a i
Please use "pgadmin-supp...@postgresql.org" for any pgAdmin/pgAgent related
questions, bugs.
On Mon, Jun 11, 2018 at 9:33 AM, a <372660...@qq.com> wrote:
> Hi all
>
> I set up a pgagent job, but it says the job was failed.
>
> But where I can have a look on error report message??
>
> I'm using pg
Hi all
I set up a pgagent job, but it says the job was failed.
But where I can have a look on error report message??
I'm using pgadmin 4.3, pgagent 3.4, postgresql 10, the platform is windows
server 2008
Thank you so much.
Hi
I'm setting up agent jobs for postgresql. I'm on win server 2008, and
postgresql 10.
I set up the jobs using pgadmin 4.3.
however, the job is not executing, may I ask why??
On 06/10/2018 02:45 PM, Alexander Shutyaev wrote:
Comments inline.
The error log is like this. Here's its tail:
Is this the regular Postgres log or the pg_upgrade log which should be
something like pg_upgrade_server.log?
pg_restore: [archiver (db)] could not execute query: ERROR: databas
The error log is like this. Here's its tail:
pg_restore: executing BLOB 1740737401
pg_restore: WARNING: database with OID 0 must be vacuumed within 103
transactions
HINT: To avoid a database shutdown, execute a database-wide VACUUM in that
database.
You might also need to commit or roll back
On 06/10/2018 02:09 PM, Alexander Shutyaev wrote:
Some more notes on databses.
Although the pg_upgrade failed, I've decided to check the databases in
the new cluster (10.4). There is no database with oid 0 either. Also to
be noted that some system databases changed the oids while others
retai
Some more notes on databses.
Although the pg_upgrade failed, I've decided to check the databases in the
new cluster (10.4). There is no database with oid 0 either. Also to be
noted that some system databases changed the oids while others retained
them.
And of my databases - sslentry. It had a ver
No database with oid 0 in 9.6 cluster:
postgres=# select oid, datname from pg_database;
oid | datname
+---
1 | template1
12438 | template0
16400 | bof
12439 | postgres
1016305714 | sslentry
(5 rows)
>> 1) OS and version you are using?
Ubu
On 06/10/2018 01:46 PM, Alexander Shutyaev wrote:
I can provide you with more info. Please tell me what you need. I really hope
someone here can help me somehow solve or workaround this, because I really
need to migrate to v10 for its features.
Well as Tom Lane said a database will not have an
Hi,
Just saw this email. Does the problem still persist?
Regards, Devrim
On Wed, 2018-04-25 at 11:22 -0400, Bruno Lavoie wrote:
> Hello,
>
> Don't know if I should post it to hackers list, by I'll try here first.
>
> For many reasons, we're currently deploying a mirror for postgresql rpm
> pa
I can provide you with more info. Please tell me what you need. I really
hope someone here can help me somehow solve or workaround this, because I
really need to migrate to v10 for its features.
Thanks in advance,
Alexander
2018-06-09 22:52 GMT+03:00 Tom Lane :
> Adrian Klaver writes:
> > On 0
I can provide you with more info. Please tell me what you need. I really hope
someone here can help me somehow solve or workaround this, because I really
need to migrate to v10 for its features.
Thanks in advance,
Alexander
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f184
On 06/05/2018 07:58 AM, Nicolas Seinlet wrote:
Hi,
I've tried some tests, by generating various datas in
the res_currency_rate table.
If I generate res_currency_rate rows for unsused currencies, this
doesn't influence the execution time.
if I generate more res_currency_rate for used currenci
19 matches
Mail list logo
