> "Moreno" == Moreno Andreo writes:
Moreno> The command I'm using is
Moreno> root@x:~# pg_dump -v -C -h -p 6543 -U postgres
Moreno> | psql -h localhost -p 6543 -U postgres
Moreno> It presents a double password prompt after I run it:
Moreno> Password: Password for user postgres:
On 11/29/18 8:12 AM, Moreno Andreo wrote:
Hi guys,
I'm facing a strange thing on my test server (Google Cloud)
On my Debian 9 box I'm running Postgres 9.6.10, and I'm transferring
some databases from another server (Debian 8, PG 9.5.15).
The command I'm using is
root@x:~# pg_dump -v
Hi guys,
I'm facing a strange thing on my test server (Google Cloud)
On my Debian 9 box I'm running Postgres 9.6.10, and I'm transferring
some databases from another server (Debian 8, PG 9.5.15).
The command I'm using is
root@x:~# pg_dump -v -C -h -p 6543 -U postgres
| psql -h
Postgres 10.6
I am getting different output using:
pg_dump -d production -U postgres -s -t container -f cont.sql
vs
pg_restore -s -t container -f container.sql production_112818.out
For the pg_dump version I get:
CREATE TABLE public.container (
c_id character varying(10) NOT NULL,
On 11/28/18 9:43 PM, Sathish Kumar wrote:
Hi,
I am trying to export and import sql file of a database. I would like to know
whether it will execute all the triggers when importing the sql dump which is
for Insert or Update or Delete.
Well you command as constructed below will have no
On 29-11-2018 08:41, R.R. PRAVEEN RAJA wrote:
Hi All,
Can i get the query or steps for how to check the Database growth in
postgres. Thanks in advance.
Regards,
Praveen
No official thing that can do the job.
You need to DIY, start collecting data (database size, connections
count, index
On Thu, Nov 29, 2018 at 08:15:10AM +, R.R. PRAVEEN RAJA wrote:
> I hope you did not understand my question. I am not asking query for
> current database size. I am asking for database growth, i mean
> predicting the increase in database size over a period like a month
> just like its available
Hello,
On 29/11/18 10:15 π.μ., R.R. PRAVEEN RAJA wrote:
Hi Andreas,
I hope you did not understand my question. I am not asking query for current database size. I am asking for database growth, i mean predicting the increase in database size over a period like a
month just like its available
Hi Andreas,
I hope you did not understand my question. I am not asking query for current
database size. I am asking for database growth, i mean predicting the increase
in database size over a period like a month just like its available in oracle.
For oracle you can see the below link.
