Tag Info

Judging from the activity on the PostgreSQL jobs mailing list I'd say it's not all that uncommon to find full-time PostgreSQL DBAs. http://www.google.com/search?q=full+time+site:postgresql.org/pgsql-jobs

"It just does". Its just meta data about the backup. The Books Online article http://msdn.microsoft.com/en-us/library/ms186299.aspx hints at it, albeit not very well in the "Remarks" section. From that article you'll see a reference to sp_delete_backuphistory. So yes you can safely remove it if you need to. The info that goes into that backupset table, ...

Yes there are, and the numbers may be on the rise. In the last 3 months of this year, I have been contacted by 3 local companies looking for full time PostgreSQL professionals, in an area typically dominated by MSSQL and Oracle (SE United States). I took one of them, and now work mostly with PostgreSQL after working with SQL Server for 12+ years. I would ...

Regarding providing DBA access, you might be better-off creating an Active Directory group and adding the DBAs into that group. That way, you can provide group-level permissions and give sysadmin to the group rather than individual users, meaning that when a DBA leaves (or a new one gets hired), you just need to adjust Active Directory rights rather than ...

How do you define the "tablespace size"? Are you interested in the total size of the data files on disk that comprise the tablespace? Or are you interested in the total size of all the segments that are part of the tablespace? Issuing a DELETE will not affect the size of the table's segment so it will have no impact on the size of the tablespace under ...

The roles in Oracle Database have no owner as well as directories have no owner. But whenever the new role is created (by user with SYSDBA role or CREATE ANY ROLE prvilege) it is automatically assigned to the user who created it. You can see what roles are assigned to which users querying DBA_ROLE_PRIVS view, or USER_ROLE_PRIVS if you want to know what roles ...

You have 6 indexes PRIMARY KEY (`UID`), KEY `FK_miii_data_miif_mapping` (`MODEL_INTEGRATION_IMPORT_FIELD_MAPPING_UID`), KEY `FK_miii_data_miif` (`MODEL_INTEGRATION_IMPORT_FIELD_UID`), KEY `FK_MIIIData_MIIInstance` (`MODEL_INTEGRATION_IMPORT_INSTANCE_UID`,`IMPORT_PAGE_NUMBER`), KEY `i_ticker` (`MODEL_INTEGRATION_IMPORT_INSTANCE_UID`,`TICKER_CODE`), ...

PG dbas are rare and hard to find. What does not make matters easier is that the going salaries can range from better than Oracle or SQL DBAs at companies that require PG for their most critical applications, and experienced difficulties finding the appropriate personnel. Others seem to try to hire on the cheap not making it worthwile for DBAs to stay or ...