2806
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
...because that's one of the HA solutions that EDB has helped customers to set up?
Читать полностью…
Well, I know if ur have skilled Engineers to setup the environment for you, then yeah u don't need EDB.
But my question is more in technical level, why still some companies prefer Patroni to EDB, and both they have support and also skilled engineers?
Which is better, and has more to offer?
Just a random question, why I have seen couples of companies still use Patroni in their HA, even though they have support from EDB?
Читать полностью…
Hello, i tried to install PostgreSQL in Linux Xubuntu 24.04 following the steps of the official website of www.postgresql.org, but i found a lot of problems/errors. Should i use the only comman "sudo apt install postgresql" from terminal as suggested from the Ubuntu website? Thanks in advance.
Читать полностью…
Anybody knows about GSSAPI authentication to AD in postgresql
Читать полностью…
Yeah, I agree. I started using PG. And I started getting more involved.
Giving support here. At least testing some patches. (They published a tiny psql patch of mine in V17).
Worked with Andrey and Nik on UUID and ULID... Which eventually led to Andrey writing UUID_V7 stuff.
Which is making it's way into PG now.
I wish I had more time and could do more. I've done some small tweaks to the Manual/HTML.
So, 1000% agree. Even if it is just testing patches.
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=78c5e141e9c13
I tried as usual psql and tried with /usr/pgsql-14/bin/psql but nothing happened even not throwing any log..
Читать полностью…
Hello All,
I'm facing one problem, can't login through postgres psql, even it's not throwing any error and can't find anything in log.
Checked server is running fine, able to check status using pg_ctl. Can can't login through psql
If you had already started your future secondary as the separate server onstance — than it needs to be resynchronised.
There are some methods to do so. pg_rewind is one of them (needs all the wals from the split point from the primary and the future replica).
rsync with the backup protocol https://www.postgresql.org/docs/17/continuous-archiving.html#BACKUP-LOWLEVEL-BASE-BACKUP is another one.
hey folks, is that any way that I can start a replication withou remove files in data folder?
context: I already have a db running(main) and another one that created and restored a backup (using barman) on it, now my ideia is to configure the second db as a replica to sync data of the main db
I'd obviously suggest PG too.
Especially having seen SQL Server installations with (hundreds of) stored procedures which were mostly there to enable functionality that with PG you either get from built-in functions or using modern SQL.
Those T-SQL shortcuts (quickly assign a value to a variable in your SQL and use that in the next query and such) sometimes come in really handy, but they often lead to sloppyness and "procedure bloat", to call it that.
I would go to the EDB Website. The primary reason we looked at it, was that it enabled converting from oracle by supporting much more of the Oracle Syntax. It has solutions for clustering, etc. Not saying they are great...
It also lets you play with the product in the cloud. They have training and support.
The company supports the ecosystem and the Open Source PostgreSQL development.
But it's designed for people who are using Oracle Enterprise, where stepping into their license is guaranteed to be cheaper than Oracle. But if you are using Oracle Standard. It's a step up in pricing, the last time I checked. But you are getting more in some regards.
I would also look around for some of their stories about companies who switched to EDB.
Patroni is free open source HA solution. Comparing with EDB is like apples to oranges. Besides if company can recruit skilled postgres dba why would they pay to third party?
Читать полностью…
sudo apt install postgresql-commonЧитать полностью…
sudo bash /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo apt update
sudo apt upgrade # will probably refresh some packages
sudo apt install postgresql-17 # or whichever release you want
https://www.crunchydata.com/blog/windows-active-directory-postgresql-gssapi-kerberos-authentication
Читать полностью…
The postgresql documentation is top notch, the internal writeups too
Читать полностью…
Lazy? Not willing to learn? Want quick results in no time? Pay up
Willing to learn? Interested in databases? Not scared of change? Welcome
can someone tell me how , how i can start using pigsty
Читать полностью…
You can configure a different directory as $PGDATA and do a pg_basebackup into that of course, but I suspect that's not what you're after... and you're pretty obviously using the Debian wrappers (pg_XXXcluster).
That means the answer is no. Deal with it, each replica starts as a 1:1 copy 🤷
1. Use the one you feel more familiar with
2. Because developer time is much more precious than db time
Last time I had the "joy" of working with SQL Server, you couldn't even redefine a _function_ that was used in any view...
Читать полностью…
Honestly it's not a fair place to ask that question. But PG would be my choice.
The stored Procedures are better and can do a lot more in PG.
But there are "issues" you could run into. A lot of DDL creates locks.
you cannot just change the type of a column if it is referenced by a bunch of views.
you are forced to drop the views, change the column type, and recreate the views.
Keep in mind, there is no multi-master write. How will you handle failover?
The way to start is to design it from the ground up. Based on your needs.
How many servers? How many sessions? Connection Pooling? Which one?
Are you converting something or writing it from scratch?
Do you need a scheduler?
Backups? Restores? Point in time restores? Developer Copies?
Developer Copies with "obfuscated" data? Staging environment?
How will you deploy? How will you host?
In my opinion, you make all of those decisions up front. And you get an education in them,
or you hire those people with the skillsets you require, and have them help build and verify as you go.