You can changing the binary path. I had added the binary path of postgresql
bin folder i.e. C:\Program Files\PostgreSQL\14\bin to PostgreSQL 14. I changed
the that and it works. Open the preferences dialog box from 'File' in the menu
bar. Then go to binary paths tab and correct it.
Bach-Nga
N
Hello,
I need some advise how to create ER using pgadmin. I am using pgadmin 4.3 and
found "New ERD Project (beta)" under Tool.
I can't drag and drop tables from browser tree to the diagram. I can manually
add tables and generate the name and retype all columns' information. Would
please show
good morning,
I want to secure a password when using the pgAdmin client to logon to the
PostgreSQL DB. No matter what passwords I put for connection with pgAdmin, all
connected fine. I have configured pg_hba.conf with md5, it works to prompt me
for a password in the DB server as use psql. If
ersjc
From: Pepe TD Vo
Sent: 31 March 2020 16:51
To: Pgsql-admin ; Pgsql-general
; PgAdmin Support List
; JC JC
Subject: Re: migrate off oracle data to postgres I have tables ddl data
definitions already. Only need to move the data over off Oracle to Postgres
Bach-Nga
No one in this world is pur
my limited experience I never
encountered any issue on the limit on data being transferred, but definitely
the load time vary depending on the environment.
Regardsjc
From: Pepe TD Vo
Sent: 31 March 2020 15:15
To: Pgsql-admin ; Pgsql-general
; PgAdmin Support List
Subject: migrate off oracle
Hello,
I have a huge data on Oracle, would you please suggest how to migrate all data
off Oracle to Postgres? Do I need to export into csv and upload to postgres?
Ora2pg is limited data from oracle to postgresql right?
Bach-Nga
No one in this world is pure and perfect. If you avoid people fo
*** Sharing success
On Thursday, December 19, 2019, 07:12:54 AM EST, bw
wrote:
Did you try
root su -c postgres pg_dumpall > postgresdump.sql
On Wed, 18 Dec 2019 at 19:55, Pepe TD Vo wrote:
>
> hello expert,
>
> I had to do a backup on replication master-slave servers. I
hello expert,
I had to do a backup on replication master-slave servers. I also have asked
this question before, but I don't understand why I followed the information
and same scripting to run on the replication servers and didn't work. I can
run pg_dumpall successful but not with the script.
he systemd process if you manually start/stop/restart
PostgreSQL by hand. Always use the service or systemctl command for doing
anything.
—Jay
Sent from my iPad
On Dec 5, 2019, at 10:31 AM, Pepe TD Vo wrote:
yes I do have a righ systemd service file named 'postgresql-11' and i
rote:
Do you have a systemd service file named `postgres-11`? If so, what are the
contents of it and the location of the file on the file system?
On Wed, Dec 4, 2019 at 1:39 PM Pepe TD Vo wrote:
the permission and owner are right. to add the authentication into the
pg_hba.conf but when I
right, sometimes if you edit a conf file it changes
owner and access permission
En 4 de diciembre de 2019 18:55:38 Pepe TD Vo escribió:
Hi experts,
I am trying to install Postgresql 11.1 replication master-slave. The
configure, make and make install went well. Initdb to the shared drive and
psql a
Hi experts,
I am trying to install Postgresql 11.1 replication master-slave. The
configure, make and make install went well. Initdb to the shared drive and
psql are up and running. After configured pg_hba.conf and postgresql.conf, I
can't restart the service and/or reload. Error is:ATHENTICAT
12 matches
Mail list logo
