Most voted "postgresql-administration" questions
19 questions
Sort by count of
-
6
votes2
answers10814
viewsHow to set password for Postgresql administration?
I installed Postgresql on my Ubuntu using "apt-get". I’ve been using "sudo" to perform operations (actually following a tutorial), but now I want to manage DBMS with a client that asks me the…
-
3
votes1
answer60
viewsIs there any protection for the files generated with pg_dump?
There is protection of files generated by pg_dump? Anyone who has access to this file can restore it in any other database with pg_restore? Is there some protection in this file, some kind of…
-
1
votes1
answer263
viewsBD modeling for "multi-level marketing"
Personal talk, I’m working on an app that consists of people referral, same as so-called multi-level marketing. The general idea consists of: Person A indicates person B (LEVEL 1) if person B…
-
1
votes1
answer1643
viewsHow to create Server in Postgresql with port other than 5432?
It is possible to create a server within the Postgresql database with a port other than 5432 ? It is possible to have Server1: Postgresql at port 5432 and Server2: Test at gate 5433 ??…
-
1
votes1
answer318
viewsHow to pick up the percentage of Postgre database storage space via EF Core in Asp.net Core
I need to create in my application a feature that checks in the database (PostGreSQL) the percentage of storage space used to be shown in a graph. I have a generic repository, and I thought I’d…
asp.net entity-framework postgresql asp.net-mvc-5 postgresql-administrationasked 6 years, 3 months ago Master JR 1,853 -
1
votes1
answer31
viewsPsql -c is lowering my table name
Hello, I am executing the following command: psql -d copia-local -U postgres -c "COPY "Questions" FROM '/home/pedro/Documents/PostGre/data/cooked/Questions_cooked.txt' WITH DELIMITER '|' NULL AS ''"…
-
0
votes2
answers1404
viewsHow to give permissions to user groups in Postgresql?
*All registered users who are members of the "ACCESS SITE" will have the same permissions. I created a group of users (Group Roles) in Postgresql called "SITE ACCESS" to put all users (Login Roles)…
-
0
votes1
answer42
viewsPostgresql - Foreign Key after import
I have a database in Firebird and I am passing the data it to Postgresql, so I made an application that reads the data from Firebird and inserts it into Postgresql. The database is from a…
-
0
votes0
answers186
viewsSQL script to adjust decimal point of a column - Postgresql
I have a table in Postgresql that has the field IdProduto and Quantidade. The values in the column Quantidade were recorded to the wrong decimal places. Ex: It was recorded 9000,000 when it should…
-
0
votes1
answer506
viewsPassword when executing postgresql command
Good morning, I am trying to create a database in postgresql via terminal in windows. But ask me for a password every time I give the command. I tried to use the password of the user postgres but…
-
0
votes1
answer88
viewsA Rigger that checks the deadline for all products in the table
Good afternoon to everyone in the community. I’m trying to make a Rigger that checks the products that have their expiration date and change their status in the table using postgresql
-
0
votes0
answers83
viewsPostgresql, csv file import
I am having a lot of difficulty trying to import the CSV file using PostgreSQL, apparently the program is not able to read the file, but granted permission in all users and folders of the operating…
postgresql postgresql-administration postgresql-10 postgresql-11asked 3 years, 11 months ago Lucaa 5 -
0
votes1
answer69
viewsPurpose of a foreign key name
I am creating tables for a system I am developing and when entering the part of adding foreign key through the interface of PostgreSQL 9.3.17 I noticed you have the field nome to identify this key,…
database postgresql pgadmin postgresql-administrationasked 5 years, 11 months ago David Alves 2,470 -
0
votes1
answer209
viewsBackup in Postgres
postgres has some system table you can select to find out when the last backup was done just like its status (it ran normal or failed) ? That is, how to remove as much backup information in postgres…
-
0
votes2
answers1039
viewsTable in Postgrethe ID field is not auto incremented
I’ll explain my problem: In my SQL system already came the error in INSERT, stating that the id field, which is autoincrement is stating that it is null: INSERT INTO cliente_sub_grupo…
-
0
votes0
answers50
viewsError when grouping per month with INNER Join using Postgres
Good morning! I’m trying to group my table by month but it’s not working.. I’m using this query: SELECT "Boleto"."id", sum("valor_parcela") AS "volume_operado", sum("spread") AS "spread",…
-
0
votes0
answers11
viewsProblems with ADMINER/Postgres
I’m using Docker to use Adminer and Postgres together. However, Adminer is rejecting my password that I put in Postgres, I did not understand very well the reason, since I reviewed the Docker code…
-
0
votes0
answers19
viewsLimit access to objects in Postgres
I created a user in postgres so that a certain employee can run only one view available in the bank. I used the following query s: CREATE ROLE LOGIN_FUNCIONARIO WITH LOGIN PASSWORD '999999'…
-
-1
votes1
answer207
viewspgAdmin - How to install "system Tray plugin"?
I use pgAdmin 4 in Linux Mint 19.3. Whenever I open the program, in addition to the browser, a pop-up appears saying: Note: Installing a system Tray plugin will Prevent this window being Shown. I…