superuser to creat an issue

[dire pewter]

Description of the problem - my user in the remote database Elephant does not have superuser rights (as far as I understand). I simply do not understand how these rights can be transferred to him in such a case?
Done - I tried to google how to solve this, but at the moment, as far as I understand, it is not possible to solve it through the Elephant interface itself.
How can it be done correctly?

[queen umbra]

• is there a reason why "remote" is mentioned? does that affect anything.
• Superuser as in, a django user with is_superuser set to True?
• Transferred implies a source and a target, or do you just mean given?

[acoustic carbon]

• what is the "remote database Elephant" and the "Elephant interface"? Do you mean Postgres, because the database logo is an elephant?

[dire pewter]

Yes, it is remote database as remote postgres db

Remote implies not local db but db existing in Internet server

[dire pewter]

Yes, I meant given. I just used translator to translate text from my native language

[queen umbra]

So i presume you mean your database user, correct?

How are you accessing the postgres interface?

[dire pewter]

Yes, database user

[dire pewter]

Via PgAdmin client

[queen umbra]

and do you have access to any other account on that database with superuser rights?

[dire pewter]

I have created one account for this db, using Google for registration

No other accounts at all

[dire pewter]

In my certain case I am rumminating on edge mean to solve this issue - totally tear down remote db and the repeatedly create just new one just the same content.

But I think as of now I can do it in other more simple and not extreme way

[acoustic carbon]

Can you explain what you mean by this bit?

does not have superuser rights (as far as I understand).

Do you mean a Django user, or do you mean a postgres user?

Do you mean your Django app can't connect to the database and create tables, or do you mean your app is working but a user in the Django user's table doesn't have the is_superuser flag set?

[dire pewter]

User for remote database

[acoustic carbon]

The user Django users to connect to Postgres as?

[dire pewter]

User whome I put in settings file as database user for remote database

[acoustic carbon]

Okay. So if that user isn't a superuser, what problem is that causing?

Migrations unable to run?

[dire pewter]

Issue is that I can't run tests now at least

[acoustic carbon]

Tests shouldn't talk to the production database...

[dire pewter]

What?

[acoustic carbon]

https://docs.djangoproject.com/en/5.0/topics/testing/overview/#the-test-database

[dire pewter]

At the crux I put test directory on GitHub as well, and those test should be available for other people who will observe my project - to run those tests by those people

[dire pewter]

Well I see your point. And in the essense it's strange that it showed such message, because test running should create temporary test database which is separate from main db

[dire pewter]

I mean official documentation is important but every issue is individual and requires clarification how to use rules in this case

[acoustic carbon]

Half the skill of being a decent developer is being able to read and understand documentation, and then apply that to your specific use case.

What "remote Postgres" platform are you using, and have you checked their docs for how to create users with the privileges you need as detailed in that documentation about test databases on Postgres?

[dire pewter]

ElephantSql

[acoustic carbon]

Important Notice: ElephantSQL is shutting down. Read all about it in our End of Life Announcement
You probably want to look into moving from that…

Are you using the free tier of ElephantSQL?

[dire pewter]

Free plan, yes

[dire pewter]

In my case I can't. Well, as alternative you can recommend me another solid db, such as Elephant with free tiers

[acoustic carbon]

Then that's likely your issue. It seems that that plan doesn't let you create additional databases per user, which Django needs to be able to do when running tests.

[dire pewter]

Besides Elephant could you recommend another one with free tiers

[acoustic carbon]

No idea I'm afraid. I don't use any hosted Postgres platforms.