Re: A particular database to move to other drive

2017-11-26 Thread Andreas Kretschmer 
On 25 November 2017 21:13:22 GMT+01:00, nikhil raj  
wrote:
>Hi,
>Any one can please help me out
>
>I want to move a database to 'Y drive' because the size of that
>database is
>large about so can I move only that database to because I got an alert
>of
>low space is there any way
>Currently it is on F drive I want to move to Y drive .
>
>Thanks


You can create a new tablespace on that drive and move the db using alter 
database ...

Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company

Error installing PostgreSQL 8.3 (password short, not complex)

2017-11-26 Thread Tomas Guerra 
Hello,
I have already read the response to this problem here:
https://www.postgresql.org/message-id/BAY123-F33A4637C55066E65749D2EA9F10%40phx.gbl
 But, I have the same problem but I cannot change the Postgre password because 
it is installed by another software called LINCS II, which is a software from a 
dealer.
The same setup works on other computers, therefore is a problem of policy 
configuration. I have tried with the Local Policy but I have the same problem. 
I cannot change the domain policy but I think that could be the issue.
 I would really appreciate your support with this. Maybe you can tell me how to 
avoid the require of a complex password during the installation of postgre.
 Best regards,
Tomas


Tomás Guerra | Loader Coordinator
*:+507 000- | Ë: +507 66768250 | *: 
tomas.gue...@fqml.com
Dirección: Torre de Las Américas. Torre A. Piso 21 - Iguana Mall, Penonomé - 
Donoso, Colón | www.cobrepanama.com
¡Únete a la conversación Twitter, 
Facebook, 
Instagram y 
Youtube!
[cid:image001.png@01D3557C.1FBFDE50]

Re: Roles and security

2017-11-26 Thread Laurenz Albe 
nikhil raj wrote:
> Currently my company is shifting from MS SQL to postgres
> 
>  check the roles of user I want to give user roles only select, insert, 
> update, execute and create database to all users Permission
> 
> 
> The users should not have these permission
>  drop database , delete table permission

If you want to allow a user (or role) CREATE DATABASE, give them the
CREATEDB privilege with ALTER ROLE.

If you mean "schema" when you say "database", give them the CREATE
privilege on the database instead.

SELECT, INSERT, UPDATE and EXECUTE are granted on individual objects,
not in general.

You can, however, use ALTER DEFUALT PRIVILEGES to automatically grant
privieges on any new object created.

Note that by default, everybody (the special role PUBLIC) has EXECUTE
privilege on all functions.

Only superusers and object owners are allowed DROP and ALTER on objects,
and there is no way to prevent that.

Yours,
Laurenz Albe

Re: equalant of msdb in sql server

2017-11-26 Thread Daniel Gustafsson 
> On 26 Nov 2017, at 17:54, chandra sekhar  wrote:
> 
> sql server has msdb database which stores the history of backups taken.
> is there any table in postgres which keep track of when the archive log files 
> are archived ?

This is the mailinglist for the postgresql.org website, you are better off
asking general postgres related questions on pgsql-general@ (cc:ed here).

cheers ./daniel

Re: declarative partition by list, "other values" syntax

2017-11-26 Thread legrand legrand 
Found it in pg 11devel:

CREATE TABLE wiki_data_part_a PARTITION OF wiki_data_part DEFAULT;




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: equalant of msdb in sql server

2017-11-26 Thread Craig Ringer 
On 27 November 2017 at 04:59, Daniel Gustafsson  wrote:

> > On 26 Nov 2017, at 17:54, chandra sekhar 
> wrote:
> >
> > sql server has msdb database which stores the history of backups taken.
> > is there any table in postgres which keep track of when the archive log
> files are archived ?
>

No, there isn't.

-- 
 Craig Ringer   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services