- Postgres Rocks
- :
- About Mediis
turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
About Mediis
since
06-27-2017
07-03-2018
Mediis
Level 2 Adventurer
12
Posts
1
Kudos
2
Solutions
07-03-2018
09:47 AM
I found this table it is not what I'm looking for. I'm looking for a record of each and every time a wal file has been archived. That way you can determine the system usage over a period of time.
... View more
07-02-2018
10:35 AM
Is there at table or a switch in the postgresql.conf that will allow me to see a history of the wal archives and when the wal archive command was run?
... View more
- Tags:
- PPAS
Labels:
06-11-2018
09:47 AM
Nope. Not a poor network. So far this is the only query causing the issue. The query runs fine in Oracle without any problems. There are three SR's open with Oracle and right now it is generating errors they have never seen before. And my favortie says file #203 is corrupt. And there IS NO file #203. --Mark
... View more
06-04-2018
09:48 AM
No, that did not answer the question. The answer is information_schema.table_privileges . DBA_TAB_PRIVS tells you the kinds of access you have on database objects. Privileges are a seperate catagory.
... View more
05-29-2018
01:34 PM
One of my developers is trying to get his queries to work through an Oracle link. This is what he gets: psqldb=> insert into ebi.STU_MULT_PLN_WITH_MULT_CLS_T select * from STU_MULT_PLN_WITH_MULT_CLS_T@oracledb; ERROR: OCI error: ORA-03114: not connected to ORACLE And this is what I get on the Oracle side: Errors in file /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/trace/DTR1STG_ora_17782.trc (incident=456641): ORA-00600: internal error code, arguments: [kposclobrcbk-8], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/incident/incdir_456641/DTR1STG_ora_17782_i456641.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Tue May 29 10:00:06 2018 Dumping diagnostic data in directory=[cdmp_20180529100006], requested by (instance=1, osid=17782), summary=[incident=456641]. Errors in file /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/trace/DTR1STG_ora_17782.trc (incident=456642): ORA-00600: internal error code, arguments: [17114], [0x7F0F5FF64368], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kposclobrcbk-8], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/incident/incdir_456642/DTR1STG_ora_17782_i456642.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Tue May 29 10:00:06 2018 Sweep [inc][456641]: completed Sweep [inc][456642]: completed Sweep [inc2][456641]: completed Tue May 29 10:00:07 2018 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7F0F642EB4D0] [PC:0xC66B4B0, kghfrh_internal()+448] [flags: 0x0, count: 1] Errors in file /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/trace/DTR1STG_ora_17782.trc (incident=456643): ORA-07445: exception encountered: core dump [kghfrh_internal()+448] [SIGSEGV] [ADDR:0x7F0F642EB4D0] [PC:0xC66B4B0] [Address not mapped to object] [] ORA-00600: internal error code, arguments: [17114], [0x7F0F5FF64368], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [kposclobrcbk-8], [], [], [], [], [], [], [], [], [], [], [] Three core dumps to one query. They are new errors in the ORA600 Diagnostic Tool. So I opend SR's for all three. Anyone seen anything like this? The extension used to create the DB LINK is EDB_DBLINK_OCI --Mark
... View more
Labels:
04-12-2018
11:46 AM
What table would I need to view to see what role has access to a database, schema and table?
... View more
Labels:
04-12-2018
11:40 AM
Problem: How do you veriy an account is no longer a locked account? Background: EDB AS the view DBA_TABLES. It uses a function, edb_get_role_status() to get the account status for the user. Where would I find a list of locked users in the pg_ tables? I see rollockdate in pg_authid but that field is still populated when I unlock an account.
... View more
Labels:
01-19-2018
10:35 AM
1 Kudo
Yep, that was the problem... too many archived wal files. Apparantly the sever had been configured for backups, but not actively backed up since last July. Changes were made, backups cronned and ... Error code 127. resolution: 1) compresed the archived wal files 2) ran bart mange -s ${server} 3) ran hot backups 4) ran bart manage -s ${server} -d ### because I didn't really need thing that old.
... View more
01-19-2018
09:26 AM
Does anyone know what this means: 2018-01-19 09:14:20 EST ERROR: command failed with exit code 127 The cause was from a $(bart manage -s ${server}), and ${server} is a valid entry in bart.cfg. I ran it with the "-d" to see what was happeneing and it happened just after it listed all of the walarchives, about 6600. My current therory is I maxed out the process list for the shell. So I'm manually compressing the walarchives. Just wondering if anyone knows.
... View more
06-29-2017
09:43 AM
It is not what I'm looking for. To directly reference the link you provided, it says Bart will accept invalid options for -t, -x, -g. I am specifically asking for the definitions of "validity". How do you use these options ? Can I use -t and -g together ? What are the options that I can use in conjunction with -t such that I can successfully restore a specific timeline ? And what files are needed for this to happen? Do I need a 00002.history file to restore to a timeline-Id of 2?? Bart is clear. But the Postgres documentation on timeline _id recovery is sparse, vague, and lacking. I'm asking for someone to rectify that.
... View more
06-28-2017
09:16 AM
I can not find documentation on restoring with a timelineid. When using Bart 1.1.1.1 how do you use the timelineid option? Is it just the timelineid switch or can I combine it with the physical time switch and/or transactionid switch for my PITR.
... View more
Labels:
