Solved

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

Posted on 2009-07-15
5
549 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 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
LPT Port to USB Printer Windows 7 23 739
Reset Log Generation 3 24
windows 2012 r2 standard  licensing re hyper-v 4 52
Help with internal NTP server 12 53
Hallo! I guess almost every Windows Administrator must have got stumped with this question "Where does WINDOWS store a users cached credentials? Every user who had once logged onto a Server/Desktop while it was connected to the domain could sti…
Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
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…

830 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