Jump to content

walter21

Members
  • Posts

    13
  • Joined

  • Last visited

walter21's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. if you do not have another solution, yes, but wolstech had some problems when importing why the database is for a newer version, and also need to be by command line, because the interface has no way, why its size is a bit great, but wolstech got it.
  2. I'll wait for the Krydos, if it has a better way, so you do not go through all the import work again. Thanks again
  3. So if I create a user with the same name of the current bank owner (walter_cidade) and grant the user access to the bank, this solves my problem, am I right? edit: I tried and I can not, show this message Postgres :: adduser (cidade, walter21) failed: (XID ecr2rg) The database "walter21_cidade" already exists, and you, "walter21", are not allowed to create a user with the same name.
  4. Does someone else have access to your account? yes, someone else had access to the database, but it was the root administrator wolstech, he helped me a lot, he imported the database for me, why can not import through the pgphpadmin interface, why the bank is a little big, I believe that without intention he put the owner of the database that user walter21_cidade, instead of walter21_walter, how do you Krydos assign the walter21_cidade bank to the owner walter21_walter? Thanks in advance. Allow me to apologise for my English
  5. Thanks for replying Krydos, I have already done this, I am sending the printscreen as is, I assign all the privileges to user walter21_walter even so he can only access the tables in schema public, I am sending a printscreen that who is as owner is walter_cidade , but I did not create this user. https://prnt.sc/ibc39c https://prnt.sc/ibc333
  6. Hello, my walter21_walter user is not able to query on tables with schema that is not public, I was only able to access tables within the public schema, even granting privileges to that user in other schemas, I want to know if I have to put the user walter21_walter as owner for all tables of all schemas?
  7. I exported a specific table and it worked, so it really should be because of the size of the database, I believe all my doubts have been answered, thank you again.
  8. Just one more question, about exporting the database, structure and data, the dump is coming empty, why? I'm following this step-by-step: I click on the database, then click on export, I finally choose structure and data, I choose the SQL format and click on export, it downloads the dump.sql file but it is empty.
  9. Oh my God, I'm sorry for all this work, and thank you very much and congratulations for the effort and commitment you had in helping me solve this problem. The bank really is for version 9.x. I believe that only with the squema that you imported the system works, the other file is just the demo.Can you answer me a question? did you import from the command line, why the phppgadmin interface really would not work? thank you again. Sorry for taking time to respond you.
  10. It's walter 21_cidade, sorry for the mistake
  11. Ok, upload the two files to the home folder, their names are "e-city-2018-1-demo.sql" and "e-city-2018-1-schema.sql" for the walter21_city bank, thanks again wolstech.
  12. Thanks for your reply Wolstech, I tried to import by PhpPgAdmin web interface, but it appeared the message "on the server found", possibly did something wrong, and if you can import it to me, are two SQL files in the link that I am sending: https://www.dropbox.com/sh/qv7yjrjxh7n6ydq/AAAkBhBhWtZZl9MueXsLVCika?dl=0 the two files need to be imported into the walter21_city bank, my user is walter21, Thank you very much!
  13. Hi, I'm trying to import a database into phppgadmin, but the message "no server found" appears in the installation document, it is done by linux commands, ex: psql -U [user] -d [db_name] -f /home/walter21/e-city-2018-1-schema.sql, then resolve to put this command, in cron, but also not made the import, please could help me to import, thanks! sorry for my bad English, I am brazilian.
×
×
  • Create New...