2656
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
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.
If a company lacks technical experties and does not have access to desired talent then it would make sense. I have seen a management which was scared of moving out of Oracle Support's "imaginary" safety net and needed something with "Enterprise" tag prefer EDB Postgres over Postgres. There maybe few who are using it for some special features that EDB offers such as Bidirectional replication and EDB distributed.
Читать полностью…
Hi
Can anyone suggest good sight for learning "pg_auto_failover" extension??
Better rule, blockchain is just a slow and expensive database. Don't come here unless you can reach 100Million tps at half of the postgres cost.
Читать полностью…
🔗 We are looking for a developer (blockchain)
About the company:
Decentralized platform
Responsibilities:
Development and implementation of blockchain solutions for specific tasks.
Creation and testing of smart contracts.
Support and optimization of existing blockchain systems.
Ensuring the security of blockchain applications.
Requirements:
Experience developing on solidity rust (from 2 years):
Experience creating and testing smart contracts, including decentralized applications (dapps).
Knowledge of the defi, nft, and other blockchain-based applications protocols.
Ability to work with web3. js, ethers. js or other libraries for interaction with ethereum.
experience with truffle, hardhat or similar frameworks for developing, testing and deploying smart contracts.
experience with any of the frames (vue, react, svelte)
conditions:
remote work
work in sprints
performance bonuses
salary - $5000-25000 (payment in usdt) (depending on development experience, negotiated separately)
write me a DM, I may not respond right away
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.
... or the better Oracle compatibility. Many if not most don't realize they replace a proprietary product with another one 🤷
Читать полностью…
Hello Everyone,
I need some information on the scenarios where a company might prefer using EDB PostgreSQL over the open source version of PostgreSQL.
What factors or requirements typically lead companies to choose EDB PostgreSQL?
What advantages does EDB PostgreSQL offer compared to the open source version?
If there are any blogs or articles covering this topic, please share me.
Can any one comment which one is better for an enterprise application which has more than 1000 tables and 8000 stored procedures .
Ms SQL server or postgres
1. Which one to use
2. Why
It is going to be a saas based product, it is an ERP solution for industry
Maybe we should add a rule "if you're involved in crypto or blockchain stuff, dump your s**t somewhere else"? 🤔
Читать полностью…
We just set up a group dedicated to PG freelancers/small businesses in Europe. Topics will (probably) be jobs, rates, experiences w/ clients, improving visibility etc. pp.
Since I don't nearly know all of you out there, join us if you're interested:
/channel/+GUaaD3HwQ98zNGYy