Php

Search

pg_dump with user name password

pg_dump --dbname=postgresql://username:password@127.0.0.1:5432/mydatabase

OR

Create a .pgpass file in the home directory of the account that pg_dump will run as.

The format is:

hostname:port:database:username:password
Then, set the file's mode to 0600. Otherwise, it will be ignored.

chmod 600 ~/.pgpass
pg_dump -h 127.0.0.1 -U user db_name > file_name.bak

Comment

PREVIOUS	NEXT

Code Example
Php :: show featured image in post wordpress
Php :: php set status code
Php :: how to alias table name in laravel model
Php :: php migrate comand
Php :: symfony get path to route
Php :: check for headers laravel
Php :: php get option value
Php :: wp_query post by category taxonomy
Php :: how to display the site tagline in wordpress
Php :: the requested php extension bcmath is missing from your system
Php :: type casting in php
Php :: php file download from url
Php :: woocommerce phone number not required
Php :: whereHas site:https://laravel.com/docs/
Php :: get current authenticated user laravel
Php :: laravel validation in controller
Php :: General error: 1390 Prepared statement contains too many placeholders
Php :: magento 2.3 check if customer is logged in
Php :: wpdb get last query
Php :: in_array associative array php
Php :: Laravel Eloquent Query Using WHERE with OR AND OR?
Php :: laravel where
Php :: php date diff in days
Php :: how to link image in laravel
Php :: implode example in php
Php :: php get embed code from youtube url
Php :: loop in loop wordpress
Php :: laravel model with migration
Php :: laravel eloquent remove from db
Php :: laravel collection average

Search

PHP

pg_dump with user name password

ADD CONTENT