我在试图丢弃数据库时发现这一错误,即输入。
linuxuser $ sudo su postgres
linuxuser $ [sudo] password for linuxuser:...
$ pg_dump -h localhost mydb >tempfile
$ sh: cannot create tempfile: Permission denied
问题是什么? i 刚安装了新鲜电.。
书写邮资用户可读书的名录。 例如/tmp。
$ pg_dump -h localhost mydb >/tmp/tempfile
在您的尝试中,用户试图在属于其他用户的一些随机名录中建立一个档案。
任何了解邮政超级用户密码的未设名用户可以通过更改对工作名录的许可来提供反馈和恢复:
% mkdir backup
% chmod 0777 backup
% su postgres
[enter password]
$ cd backup
$ pg_dump mydb >tempfile
$ exit
“雇员档案”将由邮资拥有,与用户相同。
sudo su postgres doesn t change the current directory so you re still in linuxuser s home directory and postgres has no permission to write into it. Change to a different directory
postgres User正如其他正确的答复所述,你试图挽救背书的夹没有被分配到<代码>postgres用户(操作系统用户账户)上。 <代码>postgres的用户是运行备份的用户。 该用户账户是在邮政安装过程中设立的。 您可能使用不同的名称,但缺省为postgres。
解决办法是,在postgres的用户有读标准许可的情况下,找到或创建倍。
在Maceau X(Mountain狮子)中,我能够在Finder中设立这样的一倍。
postgres_backups.File > Get Info.Sharing & Permissions section.postgres user from the list.Privilege column, for the new postgres row, change the popup menu to Read & Write.Get Info window. Done.现在你可以指导你的工作。 寄回文件。
By the way, I use the pgAdmin app to do backups and restores. Control+click on the desired database and choose Backups…. The pgAdmin app was probably bundled with your Postgres installation.
首先,你必须做的是不要转而使用员额。 利用这一指挥进行后备:
pg_dump -U username -h localhost dbname > /db.sql
就我而言,我必须写上一个完整的档案名称,如垃圾场5。
我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。
On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...
I ll take the simplest of the SQL functions as an example: CREATE OR REPLACE FUNCTION skater_name_match(INTEGER,VARCHAR) RETURNS BOOL AS $$ SELECT $1 IN (SELECT skaters_skater.competitor_ptr_id ...
I m 在当地网络上运行几台机器,在Salgresql8.3处撰写一份申请。
I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.
Hey, I have 2 tables in PostgreSql: 1 - documents: id, title 2 - updates: id, document_id, date and some data: documents: | 1 | Test Title | updates: | 1 | 1 | 2006-01-01 | | 2 | 1 | 2007-01-01 |...
I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...
I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...