Skip to main content

Search

Items tagged with: PostgreSQL


 
Gibberfish Social has undergone a major overhaul this weekend.

First, the database has been converted to from MariaDB to PostgreSQL, which has led to a noticeable speed-up in stream loading time.

Second, the single server has been split into two: One which holds the database and user-uploaded content, which uses full-disk encryption. The other runs the Diaspora, Movim, and chat servers and holds no data of its own. Both new servers are ARM64-based systems, which do not have hardware backdoors like those designed into Intel and AMD chipsets.

This is not only a little bit cheaper to run than our old server, but allows us to easily scale by adding more application servers if the need arises. "Cheaper" doesn't mean free, though, so if you enjoy the services provided by this pod, please consider making a donation to help support it. Thanks!

#gibberfish #diaspora #movim #xmpp #postgresql #arm #arm64
Make a Donation


 
There will be some downtime today as we attempt to migrate the database from MariaDB to Postgresql to improve performance. Thanks for your patience.

#gibberfish #database #mariadb #mysql #postgresql #maintenance #downtime


 
Hardware-Archiv jetzt im WordPress

Moin,
ich habe gerade mein Hardware-Archiv von meinem MediaWiki nach WordPress umgezogen, weshalb hier einige neue Artikel entstanden sind. Ich hab nämlich irgendwie meine Wiki-Datenbank geschrottet, so das keine neuen Artikel mehr angelegt werden können. Daher werde ich auch alle anderen Beiträge im Wiki noch auf WordPress migrieren und das Wiki dann schließen und löschen.

Ich trenne mich damit dann von einer weiteren MySQL-Datenbank. Diaspora* und Synapse habe ich bereits auf PostgreSQL migriert.

Leider wird wohl MySQL ein stetiger Begleiter bleiben, da sich WordPress leider nicht so ohne weiteres auf PostgreSQL umstellen lässt. Auch ein paar andere Dienste wie der Webmailer laufen auch weiterhin also auf dem MySQL-Backend. Damit habe ich zwar zwei Datenbanksysteme auf dem vServer laufen, aber das ist auch noch recht übersichtlich was wo wie läuft.

#... show more


 
#docker #PostgreSQL #RabbitMQ #python #rootless
[attachment type='link' url='https://twitter.com/muayyadalsadi/status/1105047189880012800' title='أبو العماد on Twitter' image='https://pbs.twimg.com/media/D1XqflaX4AAmgpA.jpg:large']“with latest podman (commit 349e69) and podman-compose, you can run unmodified complex #docker-compose.yml files, like those of @ansible awx (#PostgreSQL, #RabbitMQ, and #python web application and task executor) all #rootless! @rhatdan

[url]https://t.co/6XHubHJ3M5”[/attachment[/url]]


 
Somehow I missed that #postgres 11.2 had dropped. It's fully compatible with 11.1 databases, no need to dump and restore.

#postgresql


 
okay ... for a final time, let's make things clear.. ;)

#gplusrefugee [ \ | /#] #diaspora user and #fediverse netitzen Transition Status: Complete.

Now i wanna try to figure out how i can run #friendica on a #postgresql server and so open up my own little #pod.. Well, time will tell. ;)

.oO( P.s.: NO i don't want to install mariadb/mysql ... but i fear i have to install it for other cloud-thingie stuff anyways :( )


 
okay ... for a final time, let's make things clear.. ;)

#gplusrefugee [ \ | /#] #diaspora user and #fediverse netitzen Transition Status: Complete.

Now i wanna try to figure out how i can run #friendica on a #postgresql server and so open up my own little #pod.. Well, time will tell. ;)

.oO( P.s.: NO i don't want to install mariadb/mysql ... but i fear i have to install it for other cloud-thingie stuff anyways :( )


 

Matrix


Ich hatte meinen Matrix Server für zwei Tage offline, weil ich große performance Probleme hatte.
Nach einen wechsel von Sqlite auf Postgresql-11 läuft nun alles.
Python3.5 -> 3.7 wird noch folgen.

Wenn es so weiter geht, dann werde ich die ersten Bridges installieren und mich dann von den anderen Messenger trennen.

#Matrix #Riot #Synapse #Postgresql #messenger


 

PGHoard – PostgreSQL backup and restore service for cloud object storages


PostgreSQL backup and restore service. Contribute to aiven/pghoard development by creating an account on GitHub.
Article word count: 34

HN Discussion: https://news.ycombinator.com/item?id=19285459
Posted by bjoko (karma: 383)
Post stats: Points: 114 - Comments: 15 - 2019-03-01T21:31:28Z

#HackerNews #and #backup #cloud #for #object #pghoard #postgresql #restore #service #storages
Article content:

Image/Photo

You can’t perform that action at this time.

You signed in with another tab or window. [1]Reload to refresh your session. You signed out in another tab or window. [2]Reload to refresh your session.

References

Visible links
1. file:///dev/
2. file:///dev/

HackerNewsBot debug: Calculated post rank: 81 - Loop: 417 - Rank min: 80 - Author rank: 89


 

Matrix


Ich hatte meinen Matrix Server für zwei Tage offline, weil ich große performance Probleme hatte.
Nach einen wechsel von Sqlite auf Postgresql-11 läuft nun alles.
Python3.5 -> 3.7 wird noch folgen.

Wenn es so weiter geht, dann werde ich die ersten Bridges installieren und mich dann von den anderen Messenger trennen.

#Matrix #Riot #Synapse #Postgresql #messenger


 

Matrix


Ich hatte meinen Matrix Server für zwei Tage offline, weil ich große performance Probleme hatte.
Nach einen wechsel von Sqlite auf Postgresql-11 läuft nun alles.
Python3.5 -> 3.7 wird noch folgen.

Wenn es so weiter geht, dann werde ich die ersten Bridges installieren und mich dann von den anderen Messenger trennen.

#Matrix #Riot #Synapse #Postgresql #messenger


 

Running a Bakery on Emacs and PostgreSQL


Just over a year ago now, I finally opened the bakery I’d been dreaming of for years. It’s been a big change in my life, from spending all my time sat in front of a computer, to spending most of it…
Article word count: 1798

HN Discussion:
... show more


 

Running a Bakery on Emacs and PostgreSQL


Just over a year ago now, I finally opened the bakery I’d been dreaming of for years. It’s been a big change in my life, from spending all my time sat in front of a computer, to spending most of it…
Article word count: 1798

HN Discussion:
... show more


 

Running a Bakery on Emacs and PostgreSQL


Just over a year ago now, I finally opened the bakery I’d been dreaming of for years. It’s been a big change in my life, from spending all my time sat in front of a computer, to spending most of it…
Article word count: 1798

HN Discussion: https://news.ycombinator.com/item?id=19252952
Posted by flocial (karma: 1512)
Post stats: Points: 162 - Comments: 45 - 2019-02-26T09:06:18Z

\#HackerNews #and #bakery #emacs #postgresql #... show more


 

PostgreSQL


Kann mir jemand sagen, ob #pglz auch in der Community Edition von #PostgreSQL aktive ist?

#Linux #DB #OpenSource


 
#GNU Health Federation message and authentication server drops #MongoDB and adopts #PostgreSQL
GNU Health Federation message and authentication server drops MongoDB and adopts PostgreSQL


 

PostgreSQL 11 Reestablishes Window Functions Leadership


PostgreSQL 11 offers the best OVER clause support among its competitors, true procedures, and improvements in FETCH FIRST and XML.
Article word count: 1882

HN Discussion: https://news.ycombinator.com/item?id=19165923
Posted by boshomi (karma: 323)
Post stats: Points: 141 - Comments: 10 - 2019-02-14T20:55:26Z

\#HackerNews #functions #leadership #postgresql #reestablishes #... show more


 

Fully managed PostgreSQL databases


Fully managed, and scalable database clusters without the administrative overhead.
Article word count: 37

HN Discussion: https://news.ycombinator.com/item?id=19162729
Posted by alexellisuk (karma: 1204)
Post stats: Points: 193 - Comments: 70 - 2019-02-14T15:46:05Z

\#HackerNews #databases #fully #managed #postgresql
Article content:




[1]C83f5e9d5a13bee5740ed213ddaf8a3d107d94c0 abugameslogo notext

“Our e-commerce business relies on a high-performance database. Managed Databases from DigitalOcean allow us to create a PostgreSQL environment that’s easy to configure and gives us built-in backup, redundancy, and automatic upgrades.”

Adam Fuhriman CIO at ABUGames

References

Visible links

HackerNewsBot debug: Calculated post rank: 152 - Loop: 162 - Rank min: 100 - Author rank: 18


 
#PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 released

https://lwn.net/Articles/779781/
"The PostgreSQL project has put out updated releases for all supported versions."


 


 

Red Hat Satellite to Drop MongoDB and Standardize on PostgreSQL Database


Red Hat Satellite is a complex offering and we wanted to spend some time talking about the underlying databases that make Satellite work as well as some upcoming changes to this underlying database…
Article word count: 490

HN Discussion: https://news.ycombinator.com/item?id=19158854
Posted by pplonski86 (karma: 3004)
Post stats: Points: 119 - Comments: 43 - 2019-02-14T01:19:36Z

\#HackerNews #and #database #drop #... show more


 

MyWebSQL: Administración fácil de MySQL vía web


https://www.ochobitshacenunbyte.com/2019/02/11/mywebsql-administracion-facil-de-mysql-via-web

#centos 7 #mariadb #mysql #mywebsql #postgresql #sql #sqlite #sysadmin
MyWebSQL: Administración fácil de MySQL vía web


 

MyWebSQL: Administración fácil de MySQL vía web


https://www.ochobitshacenunbyte.com/2019/02/11/mywebsql-administracion-facil-de-mysql-via-web

#centos 7 #mariadb #mysql #mywebsql #postgresql #sql #sqlite #sysadmin
MyWebSQL: Administración fácil de MySQL vía web


 

MyWebSQL: Administración fácil de MySQL vía web


https://www.ochobitshacenunbyte.com/2019/02/11/mywebsql-administracion-facil-de-mysql-via-web

#centos 7 #mariadb #mysql #mywebsql #postgresql #sql #sqlite #sysadmin
MyWebSQL: Administración fácil de MySQL vía web


 
MyWebSQL: Administración fácil de MySQL vía web

https://www.ochobitshacenunbyte.com/2019/02/11/mywebsql-administracion-facil-de-mysql-via-web/

#MyWebSQL #SQL #MySQL #MariaDB #PostgreSQL #SQLite #Linux #Centos
MyWebSQL: Administración fácil de MySQL vía web


 
MyWebSQL: Administración fácil de MySQL vía web

https://www.ochobitshacenunbyte.com/2019/02/11/mywebsql-administracion-facil-de-mysql-via-web/

#MyWebSQL #SQL #MySQL #MariaDB #PostgreSQL #SQLite #Linux #Centos
MyWebSQL: Administración fácil de MySQL vía web


 
- ✅ crear una tasca cron que obtengui la visió que té mastodont.cat del #fedivers, un cop per setmana.
- ✅ guardar les dades en un fitxer
- ✅ crear un nou guió #Python que llegeixi les dades del fitxer y les escrigui en una base de dades #Postgresql.
- ✅ crear un nou Dashboard a #grafana que mostri l'evolució del fedivers, sempre segons mastodont.cat


 
Projecte nou:
- crear una tasca cron que obtengui la visió que té mastodont.cat del #fedivers, un cop per setmana.
- guardar les dades en un fitxer
- crear un nou guió #Python que llegeixi les dades del fitxer y les escrigui en una base de dades #Postgresql.
- crear un nou Dashboard a #grafana que mostri l'evolució del fedivers, sempre segons mastodont.cat


 
@jrhawley Olga Kalinina has presented the way she works with #PostgreSQL and #R (via PL/R) during #fosdem #pgday in Brussels. She prefers R but other people also use #Python. I don't think she is on Mastodon but maybe it is a good reason to invite her and ask.


 
I could not resist buying this super cute stuffed animal from the #PostgreSQL stand at #FOSDEM. It stands stable on its 4 legs, I expected no less from the Postgres project. <img class=">
Image/Photo


 

Hacking PostgreSQL [pdf]


HN Discussion: https://news.ycombinator.com/item?id=19014665
Posted by eatonphil (karma: 3843)
Post stats: Points: 132 - Comments: 1 - 2019-01-28T00:34:45Z

\#HackerNews #hacking #pdf #postgresql
HackerNewsBot debug: Calculated post rank: 88 - Loop: 232 - Rank min: 80 - Author rank: 46


 

PostgreSQL: Backend Flowchart


HN Discussion: https://news.ycombinator.com/item?id=19011925
Posted by octosphere (karma: 4463)
Post stats: Points: 164 - Comments: 7 - 2019-01-27T14:58:38Z

\#HackerNews #backend #flowchart #postgresql
Article content:
[1]flowchart

A query comes to the backend via data packets arriving through TCP/IP or Unix Domain sockets. It is loaded into a string, and passed to the [2]parser, where the lexical scanner, [3]scan.l, breaks the query up into tokens(words). The parser uses [4]gram... show more


 
Microsoft übernimmt den Postgres-Datenbankspezialisten Citus Data #CitusData #Microsoft #OpenSource #PostgreSQL


 

Internals of PostgreSQL


In this document, the internals of PostgreSQL for database administrators and system developers are described. PostgreSQL is an open source multi-purpose relational database system which is widely…
Article word count: 379

HN Discussion: https://news.ycombinator.com/item?id=18950460
Posted by billwashere (karma: 161)
Post stats: Points: 180 - Comments: 7 - 2019-01-20T01:57:58Z

\#HackerNews #internals #postgresql
Article content:

In this document, the internals of PostgreSQL for database administrators and system developers are described.

PostgreSQL is an open source multi-purpose relational d... show more


 

HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL


HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL or…
Article word count: 401

HN Discussion: https://news.ycombinator.com/item?id=18932320
Posted by piotrkubisa (karma: 333)
Post stats: Points: 120 - Comments: 68 - 2019-01-17T16:53:32Z

\#HackerNews #and #client #for #gui #... show more


 
Hallo zusammen, ich bin #NeuHier. Ich interessiere mich für #geoinformatik, #geologe, #geologie, #hund, #hunde, #postgis, #postgresql, #qgis, #python und #triumph.
Und vieles mehr ;)
Have a ot of fun!
Uwe


 
Hallo zusammen, ich bin #NeuHier. Ich interessiere mich für #geoinformatik, #geologe, #geologie, #hund, #hunde, #postgis, #postgresql, #qgis, #python und #triumph.
Und vieles mehr ;)
Have a ot of fun!
Uwe


 
I'm going to upgrade the diaspora-fr database, so there will be a downtime tonight.

Je vais mettre à jour la base de données de diaspora-fr, il va y avoir une coupure du service cette nuit

#diaspora-fr #postgresql


 
Cool and detailed article about why and how The Guardian migrated from MongoDB to Postgres. Been wanting to mess around with Postgres JSONB document capabilities. Maybe will now. #postgresql #mongodb #scala #software #programming #database #aws #devops


 
Cool and detailed article about why and how The Guardian migrated from MongoDB to Postgres. Been wanting to mess around with Postgres JSONB document capabilities. Maybe will now. #postgresql #mongodb #scala #software #programming #database #aws


 
Cool and detailed article about why and how The Guardian migrated from MongoDB to Postgres. Been wanting to mess around with Postgres JSONB document capabilities. Maybe will now. #postgresql #mongodb #scala #software #programming #database #aws #devops


 

Hubzilla on Silverhaze.EU gone


Already announced months ago (so that the users had enough time to migrate) I've now shutdown my #Hubzilla hub running on Silverhaze.EU:

server:~# a2dissite silverhaze.eu
Site silverhaze.eu disabled.
To activate the new configuration, you need to run:
  service apache2 reload
server:~# service apache2 reload
[ ok ] Reloading Apache httpd web server: apache2.
server:~#
postgres@server:~$ dropdb hubzilla
postgres@server:~$


Hubzilla was a nice thing to try out, but I don't think that I've gained much benefit of this, because I also have #Friendica node running for years and a #Mastodon instance running for some time now.
Hubzilla is a nice software for what it is: a complete set of web applications. When you only want to have some kind of social web for the #... show more


 
@lynnesbian - well, installing #PostgreSQL 11 on #Debian testing doesn't mean that it will be used. On my unstable box the databases stayed on #psql 10 until I did a pg_upgradecluster and dropped the old cluster 10.

And of course you now that using testing comes with a risk and problems. Sometimes even worse than using Debian unstable.
For unstable you'll always need to monitor the mailing list about upcoming library transitions and such and see what will be upgraded/removed. #worksforme :)