[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Deleting and dumping a database...
- Subject: Re: Deleting and dumping a database...
- From: "Chris Travers" <..hidden..>
- Date: Sun, 18 May 2008 17:27:46 -0700
On Sun, May 18, 2008 at 5:15 PM, Zachary K <..hidden..> wrote:
> I recently screwed up in my accounting and tried deleting all of my invoiced
> to start over. Well, after viewing my chart of accounts, I realized this
> didn't work, there are still values in the C of A. So, I think deleting my
> database is the best option. How do I do this? Also, for future reference,
> how do I dump my database so I don't get this problem again?
The following are command-line tools.
I generally use pg_dump to dump my database. As of 1.3, pg_dumpall
will be needed due to the use of roles. We have tools for backing up
the database in the application but they basically do this :-).
dropdb will drop the database.
Hope this helps,
Chris Travers
>
> Thanks,
>
> Zach
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>