Create an account

Very important

  • To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
  • You will only see chat messages from people who are at or below your level.
  • More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
  • Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)


Thread Rating:
  • 337 Vote(s) - 3.47 Average
  • 1
  • 2
  • 3
  • 4
  • 5
postgresql where does the output of pg_dump go

#1
I am trying to backup a db of postgresql and I want to use `pg_dump` command.
I tried :

psql -U postgres
postgres-# pg_dump test > backup.sql

But I don't know where the output file goes.
Any help will be appreciated
Reply

#2
If you are not specifying fully qualified paths, like:

`pg_dump your_db_name > dbdump`

then in *Windows* it stores dumps in current user's home directory. I.e.:

` C:\Users\username`
Reply

#3
In my situation (PostgreSQL 9.1.21, Centos 6.7), the command

runuser -l postgres -c 'pg_dump my_database > my_database.sql'

saved the file here:

/var/lib/pgsql/my_database.sql

Not sure if that is true for other Linux dists, CentOS and/or pgl versions. According to [the answer post by the asker of this question][1], this is true, but other users said the backup file was in the current directory (a situation different of most people reading this thread, for obvious reasons). Well, I hope this can help other users with the same problem.

P.s.: if that's not the path for your situation, you can try (in Linux) to find it using the below command (as stated by @Bohemian in the comments of this question), but this can take a while:

find / -name 'my_database.sql'

**EDIT:** I tried to run the analogous command in Ubuntu 12.04 (it works on Ubuntu 18.04):

sudo -u postgres pg_dump my_database > my_database.sql

And in this case the file was saved in the current directory where I ran the command! So both cases can happen in Linux, depending of the specific dist you are working

[1]:

[To see links please register here]

Reply

#4
I'm late to this party, but I feel that none of the answers are really correct. Most seem to imply that `pg_dump` writes a file somewhere. It doesn't. *You* are sending the output to a file, and *you* told the shell where to write that file.

In your example `pg_dump test > backup.sql`, which uses the `plain` or SQL format, the `pg_dump` command **does not store** any file anywhere. It just sends the output to `STDOUT`, which is usually your screen, and it's done.

But in your command, you also told your shell (Terminal, Command prompt, whatever) to redirect STDOUT to a file. This has nothing to do with `pg_dump` but is a standard feature of shells like Bash or cmd.exe.

You used `>` to redirect STDOUT to a file instead of the screen. And you gave the file name: "backup.sql". Since you didn't specify any path, the file will be in your current directory. This is probably your home directory, unless you have done a `cd ...` into some other directory.

In the particular case of `pg_dump`, you could also have used an alternative to the `> /path/to/some_file` shell redirection, by using the [`-f some_file` option][1]:

> -f file<br /> --file=file
>
> Send output to the specified file. This parameter can be omitted for file based output formats,
> in which case the standard output is used.

So your command could have been `pg_dump test -f backup.sql`, asking pg_dump to write directly to that file.

But in any case, you give the file name, and if you don't specify a path, the file is created in your current directory. If your prompt doesn't already display your current directory, you can have it shown with the `pwd` command on Unix, and `cd` in Windows.

[1]:

[To see links please register here]

Reply

#5
Go to command prompt and directory postgresql\9.3\bin.

**Example**


.

..
c:\Program files\postgresql\9.3\bin> pg_dump -h localhost -p 5432 -U postgres test > D:\backup.sql
...

After above command enter User "postgres" password and check `D:\` drive for `backup.sql` file





Reply

#6
In pgadmin 4 for a Mac, assuming dump is successful you can click on "More Details" you will see a box that says "Running command:" in that box you will see /Applications/pgAdmin 4.app/Contents/SharedSupport/pg_dump --file "path/to/file" where path to file is the destination of storage.
Reply

#7
In the server (Ubundu/Centos) the path of backup file will be
*/var/lib/pgadmin/storage/<account_name>*
Reply

#8
If you use linux (except centos)

sudo su - postgres
pg_dump your_db_name > your_db_name.sql
cd /var/lib/postgresql
ls -l

Here your'll see your_db_name.sql file
Reply

#9
After doing

```
psql -U postgres
```

Using the command
```
\! pg_dump -U postgres humaine > C:\Users\saivi\OneDrive\Desktop\humaine_backup1.sql
```

The output file would go where the path at the right is specified
Reply

#10
For Linux default dump path is:
```
/var/lib/postgresql/
```
Reply



Forum Jump:


Users browsing this thread:
1 Guest(s)

©0Day  2016 - 2023 | All Rights Reserved.  Made with    for the community. Connected through