| PostgreSQL restore and dump Posted: 27 Aug 2009 02:35 AM PDT This is just a note to myself. This is how I create backup and restore backup of postgresql databases right now: pg_dump -U postgres -F t -b -v -f "<file name>.backup" "<database name>" -F : --format=format Selects the format of the output.t : Output a tar archive suitable for input into pg_restore. Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. It is also possible to limit which data is reloaded at restore time.-b : --blobs Include large objects in the dump. A non-text output format must be selected.-v : Specifies verbose mode. This will cause pg_dump to output detailed object comments and start/stop times to the dump file, and progress messages to standard error. - -f : --file=file Send output to the specified file. If this is omitted, the standard output is used.
pg_restore -U postgres -d <file name> If there are better ways to do this, feel free to leave a comment. Thanks! No related posts. Tags: dump, PostgreSQL, restore |
| Google Wave Sandbox Dev Preview Posted: 26 Aug 2009 10:16 PM PDT Yesterday, I was able to try out Google Wave Sandbox Dev Preview together with some of the FilDev/GTUG (Google Technology Users Group Philippines) people. It was crazy and I think most of us had fun. Or at least, I did. =D  Google Wave Sandbox Dev Preview Here are a couple of feedback from us (taken from the thread): - It’s slow on Firefox but fast on Chrome.
- The Navigation block located at the upper left corner has a scrollbar. I hate scrollbars on my navigation blocks. The navigation block still had to be resized to remove to make the scrollbars disappear (yes, almost all blocks can be resized).
- Blocks can also be minimized.
- The Reply button of the thread is at the upper left side which isn’t very intuitive. Would’ve been nice if it’s located at the bottom of the thread so it can easily be found after reading the whole thing.
- Pressing the Enter key doesn’t send the message. Pressing the tab doesn’t get you to the Done button but indents the message instead. I still have to use my mouse to click the Done button. Shortcut keys would be very useful. Ctrl + Enter hits the Done button but also creates a new reply, which shouldn’t be the correct behavior.
- Messages can be read while the person is still typing the message. I’m not sure if it’s such a good idea to have that. You can even see the person pressing the backspace
- Clicking the Manage Contacts link opens up a new window that has the same interface as Gmail. I’m quite sure it’s not the intended behavior.
- Nobody was able to change their own profile pictures
- Can’t send messages from Wave to Gmail
- To add a person to an existing thread, the person has to be in your contact list
- It’s diffcult to follow the messages since the changes are all over the thread
- Edits can be done on messages that others posted although the name of the editors will be shown
Present at the thread were: - Aileen Apolo
- Marc Lester Tan
- Jomar Tigcal
- Roger Filomeno
- Alvin Gamboa
- Nikki Ramirez
- me
Related posts: - Google Calendar on Evolution
- Google Image Labeler
- Show recent Google Reader shared items in your Facebook Wall
- Google Translate now speaks Filipino
- Allowing anonymous users to comment on Blogger
Tags: Google Wave Sandbox Dev Preview |
0 comments:
Post a Comment