restrs.blogg.se

1. #POSTICO ONLY UPDATE ONCE FULL#
2. #POSTICO ONLY UPDATE ONCE CODE#
3. #POSTICO ONLY UPDATE ONCE FREE#
4. #POSTICO ONLY UPDATE ONCE MAC#

This should hopefully fix the problem of lost connections when servers are configured with a timeout. Postico reconnects automatically the next time you try to execute a query. Or when the connection was idle for 5 minutes.

#POSTICO ONLY UPDATE ONCE MAC#

Postico now automatically disconnects from the server before your Mac goes to sleep, However, there is no graphical user interface yet for creating indexes (I will add that in a future version) You can also rename indexes, add comments, or delete indexes. This feature is currently mainly useful for informative purposes: Postico now displays table indexes in the table structure view right below the columns. Type select in the grid view: You can now just start typing to select tables in the grid view #119įilter tables & schemas in the grid view #119 You can disable this behaviour with a hidden preference:ĭefaults write at.eggerapps.Postico SanitizeWhitespace 0Īdded a "Copy with Header" command #65 #125Īdded a preference to disable Magic Mouse and trackpad gestures #129 Postico now automatically replaces non-standard space and newline characters in the SQL query view, and it strips byte order marks. You can now also disable the check altogether with a hidden preference:ĭefaults write at.eggerapps.Postico IgnoreAffectedRows 1 Of affected rows does not match what Postico expected #130 When saving changes to a table, you now have the option to commit changes even when the number Postico now correctly handles special characters in filenames (like /) when exporting. The SQL Query View now recognises statements containing semicolons #109įixed a bug where the execute button was enabled even though there was no query on the line. The interface now refreshes correctly after deleting the last index.

Postico now again shows proper error messages when saving changes failsĪdded an option in preferences to change the font size of the SQL Query text view #38 Inserting tabs into the SQL query view works as expected again Tabs in the SQL query view are now exactly 4 spaces wide #103įixed two regressions from version 1.0.1:

#POSTICO ONLY UPDATE ONCE FULL#

# You will be prompted for to enter a password (use the one you grabbed earlier).Ĭheck it works either by using the Gigalixr CLI to view the db, or use Postico with the full db url.Fixed an issue when pasting values into columns of type NUMERIC Restore using your dump file gigalixir pg -a What is important is that you can run gigalixir pg -a to check that your new db exists once you’ve created it.

#POSTICO ONLY UPDATE ONCE CODE#

Really depends on what kind you want so I’m not going to put code here. You can do this via the CLI or from the UI in Gigalixir. You should follow the instructions from Gigalixir’s docs, but to summarize: gigalixir pg -a You can only have one database per app because otherwise managing your DATABASE_URL variable would become trickier. You can’t provision a second DB with Gigalixir while you have an existing one. I confirmed the contents by connected to it via Postico.

That should dump the file into your local db called “dump_tester”. To be sure that the dump file worked, let’s test it locally. Now we have a dump file of your database. Take the value of url and run the following: pg_dump postgresql://gigalixir_admin postgresql://gigalixir_admin. To find your current DB info: gigalixir pg -a I’m not going to give instructions on this one. You should already have it already if you’re using Gigalixir. Gigalixr warns that changing db tier types is your own responsibility, which seems intimidating at first but was actually not a big deal.

#POSTICO ONLY UPDATE ONCE FREE#

Contray to the title, I actually downgrading my app to a free db (not upgraded). I have an app that uses Gigalixir and I’m paying for a Standard DB.