Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I run a dumpall in PostgreSQL in PSQL on Windows Server 2003?

Posted on 2009-07-15
5
Medium Priority
?
566 Views
Last Modified: 2012-05-07
Hello,

I am new to PostgreSQL and I need to move the databases from one server to another? I have read about a dumpall feature that will allow me to do this.. However, when I type in the command to the PSQL shell nothing happens. I am sure that the credentials are correct. Can anyone help?
0
Comment
Question by:Lanyelle
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:a_didit_m
ID: 24900926
dumpall feature in PostgreSQL is a executable program that run from windows Command Prompt. Locate the file pg_dumpall.exe in your PostgreSQL Installation directory (usually in C:\Program Files\PostgreSQL\8.1\bin>)

And then run with help argument :

C:\Program Files\PostgreSQL\8.1\bin>pg_dumpall --help

to learn about using.

Hope help


Didit
0
 
LVL 3

Expert Comment

by:a_didit_m
ID: 24900940
I'm sorry, I mean, usually the file pg_dumpall.exe reside in (usually in C:\Program Files\PostgreSQL\8.X\bin>) depend on the version of the PostgreSQL.
0
 

Author Comment

by:Lanyelle
ID: 24906497
Thanks, the main problem was that I was running it in PSQL shell with no results. You can run the pgdumpall in the WIndows Command Prompt?
0
 
LVL 3

Accepted Solution

by:
a_didit_m earned 2000 total points
ID: 24909801
>Thanks, the main problem was that I was running it in PSQL shell with no results.
There is no dumpall command in PostgreSQL shell or in SQL language.


>You can run the pgdumpall in the WIndows Command Prompt?
Yes, here the example :


C:\Program Files\PostgreSQL\8.3\bin>pg_dumpall --help
pg_dumpall extracts a PostgreSQL database cluster into an SQL script file.
 
Usage:
  pg_dumpall [OPTION]...
 
General options:
  -f, --file=FILENAME      output file name
  -i, --ignore-version     proceed even when server version mismatches
                           pg_dumpall version
  --help                   show this help, then exit
  --version                output version information, then exit
---------------------cut-----------------------------------------

Open in new window

0
 

Author Comment

by:Lanyelle
ID: 24910008
OK Ima give it a try tonight, I appreciate  your help!!!!!!!!!!!!!!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question