Re: equalant of msdb in sql server

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, t

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

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

> 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 o

Re: Roles and security

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

Error installing PostgreSQL 8.3 (password short, not complex)

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 passwo

Re: A particular database to move to other drive

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 o