skip to main | skip to sidebar

.NET webservices from the grounds up, i.e. notepad programming

in preparation for Linux Server + PostgreSQL + mod_mono and Apache + Linux .NET WebServices using Mono

Saturday, December 02, 2006

restore postgresql database

raw backup and restore of postgresql, ala-mssql's sp_attach_db.


copy the whole c:\program files\postgresql

:D


then copy to other computer, set the necessary permission(note: NTFS) , like the windows username: postgres-acct. note that postgres-su (superuser), has no bearing in windows usernames, you must not look for this user
Posted by Michael I. Buen at 10:25 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2008 (3)
    • ►  August (1)
    • ►  July (2)
  • ►  2007 (7)
    • ►  March (5)
    • ►  January (2)
  • ▼  2006 (77)
    • ▼  December (9)
      • Bleeping Computer - rundl132.exe - File Information
      • Slashdot | Google Deprecates SOAP API
      • O'Reilly Radar > Google Deprecates Their SOAP Sear...
      • How To Change The Screen Resolution in C#: " How T...
      • Varlena, LLC | PostgreSQL General Bits Newsletter:...
      • should this blog still be called .NET Webservices?
      • restore postgresql database
      • FAQ: Technical - Mono: "What is a 100% .NET applic...
      • Howto Backup PostgreSQL Databases | nixCraft
    • ►  November (7)
    • ►  October (1)
    • ►  September (1)
    • ►  August (28)
    • ►  July (20)
    • ►  June (2)
    • ►  May (3)
    • ►  April (6)

Links

  • MS SQL to PostgreSQL
  • My Site before I graduated in College
  • Google News

About Me

Michael I. Buen
The opposite of neub. A Filipino programmer
View my complete profile