cartodb4/cartodb-postgresql
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
1,369 Commits 1 Branch 92 Tags
0.36.0
Commit Graph
720 Commits
Author SHA1 Message Date
manmorjim b9615a912f Adding debug for _CDB_Group_API_Auth 2020-02-12 18:55:44 +01:00
manmorjim c8410541a4 Fix variable naming 2020-02-12 10:09:07 +01:00
manmorjim 55ebc73f9e Remove comments to fix syntax errors 2020-02-11 19:31:37 +01:00
manmorjim 027256dbb7 Make cartodb-postgresql python3 compatible 
- encoding string with python3
- adapt HTTPConnection signature to python3
 2020-02-11 18:51:24 +01:00
Raul Marin 093e0bcb36 Always use @@plpythonu@@ as variable 2019-12-26 17:59:29 +01:00
Raul Marin ca1d5b0c91 Avoid outputting python error messages in regress tests 2019-12-26 17:46:10 +01:00
Raúl Marín ecf0a06448 Merge remote-tracking branch 'carto/master' into 2273_support 2019-12-24 14:14:33 +01:00
Raúl Marín dfd26d930e Add huge warnings 2019-12-24 00:59:11 +01:00
Raúl Marín 9010642326 Revert "Revert 0.33.0" 
This reverts commit 24cb6cf9c1.
 2019-12-24 00:33:35 +01:00
Raúl Marín 24cb6cf9c1 Revert 0.33.0 2019-12-23 20:23:02 +01:00
Alberto Romeu 1c7b0c71ec use literal substitution instead of identifier 2019-12-20 16:27:03 +01:00
Raúl Marín 6ebffe1b2c PR review improvements 2019-12-17 11:26:56 +01:00
Raúl Marín b3503ea429 FederatedTableList: Fix column parsing with default names 2019-12-12 15:52:50 +01:00
Raúl Marín 3c869e3d5a FServer list: Return the username if the user has been granted access to the server 2019-12-11 18:37:26 +01:00
Raúl Marín dac135890d CDB_Federated_Table_Register: Reuse webmercator_column if geom_column is NULL 2019-12-10 18:08:25 +01:00
Raúl Marín 9372c9f4e0 FederatedServer: Fix a bug when extracting the webmercator column from the view definition 2019-12-05 16:26:37 +01:00
Raúl Marín da570c50aa Merge remote-tracking branch 'carto/master' into federated_functions 2019-11-15 13:50:21 +01:00
Raúl Marín d549ecced4 Merge pull request #385 from CartoDB/federated_functions_permissions 
Federated functions permissions
 2019-11-15 13:47:16 +01:00
Raúl Marín fde12c818a Update comments 2019-11-15 13:09:52 +01:00
Raúl Marín e99e4a02c9 Remove TODO 
Since the server registration requires superadmin priviledges
it doesn't make sense to over protect the role creation
 2019-11-14 19:00:09 +01:00
Raúl Marín fa5f0bcbc1 CDB_Federated_Server_Grant_Access: comment about search_path 2019-11-14 18:55:38 +01:00
Raúl Marín adca727169 Revert "Go back to public user mappings" 
This reverts commit 64e185b841.
 2019-11-14 18:46:45 +01:00
Raúl Marín 0893fae025 Revert "CDB_Federated_Server_Unregister: Drop owned in cascade" 
This reverts commit 1b86517007.
 2019-11-14 18:46:02 +01:00
Raúl Marín e69d3b1c30 Place all views in a shared schema 2019-11-14 18:45:09 +01:00
Rafa de la Torre a57431a04d Merge pull request #384 from CartoDB/federated_diagnostics_latency 
Federated diagnostics latency
 2019-11-14 18:29:25 +01:00
Rafa de la Torre 064cc2a76b Fix for missing port in pg_foreign_server: default to standard 5432 2019-11-14 17:57:05 +01:00
Raúl Marín 6e455efcdd Improve warning 2019-11-14 14:15:56 +01:00
Raúl Marín 1b86517007 CDB_Federated_Server_Unregister: Drop owned in cascade 
Since now views might be owned by other roles, we need to drop them
in cascade to force deletion
 2019-11-14 14:07:41 +01:00
Raúl Marín 64e185b841 Go back to public user mappings 2019-11-14 13:43:28 +01:00
Raúl Marín 38d8a470bc Federated Server: Grant all over postgis and cartodb schemas 2019-11-14 13:24:32 +01:00
Raúl Marín 4920029560 CDB_FederatedServerTables: Improve permission handling and error messages 2019-11-14 13:10:21 +01:00
Rafa de la Torre 9b91704480 Calculate stats only when they make sense 2019-11-13 19:27:56 +01:00
Rafa de la Torre 57dcfc2a35 Add a bunch of statistics 2019-11-13 18:55:09 +01:00
Rafa de la Torre 3ae7b1fe05 Fix bug: do not initialize samples in every iter 2019-11-13 18:27:14 +01:00
Rafa de la Torre f7d10adbc2 Fix another python2/3 incompat: xrange 2019-11-13 17:16:53 +01:00
Rafa de la Torre 203bd64058 Fix python2/3 compat issue 2019-11-13 17:02:22 +01:00
Rafa de la Torre 19c6de2096 Comment out suspected line 
This may be causing the error

     ERROR:  could not compile PL/Python function "__cdb_fs_tcp_foreign_server_latency"
     DETAIL:  SyntaxError: invalid syntax (<string>, line 26)

when testing in PG12 + plpythonu3
 2019-11-13 14:52:24 +01:00
Raúl Marín e231500c46 Give permissions over cartodb to the FS role 2019-11-13 14:20:08 +01:00
Rafa de la Torre 4b9c048235 Close socket properly before the next iteration 
This avoid the errors `[Errno 106] Transport endpoint is already
connected` which are due to connections kept in TIME_WAIT state.

We don't use socket.SO_REUSEADDR as it would make the first connection
a special case compared to the following ones.
 2019-11-13 12:25:41 +01:00
Rafa de la Torre 5897d8a9cb Fix timer start in measurements 2019-11-13 12:24:59 +01:00
Rafa de la Torre 980657c4a4 Do not add None to samples in case of connection error 
Otherwise we get `TypeError: unsupported operand type(s) for +: 'float'
and 'NoneType'` when calculating the average.
 2019-11-13 12:16:21 +01:00
Rafa de la Torre a4a4a1dff1 Honor n_samples param 2019-11-13 12:13:42 +01:00
Rafa de la Torre 0362825b8c Encapsulate python in __CDB_FS_TCP_Foreign_Server_Latency 
Instead of having a generic function, merge
__CDB_FS_TCP_Network_Latency and __CDB_FS_Foreign_Server_Host_PG into
one function so that it can only "ping" federated servers.
 2019-11-13 11:44:24 +01:00
Raúl Marín 9eab5e2533 __CDB_FS_Generate_Server_Role_Name: set to STABLE 
current_database() is stable, not immutable
 2019-11-12 18:15:20 +01:00
Raúl Marín 0d455d9521 __CDB_FS_List_Foreign_Schemas_PG: Remove extra role generation 2019-11-12 18:14:36 +01:00
Rafa de la Torre 18f9f79fe8 Rename key to server_latency_ms to be self-explanatory 2019-11-12 15:08:26 +01:00
Rafa de la Torre a032cc08e0 Measure latency as the avg of n_samples 2019-11-12 15:01:56 +01:00
Rafa de la Torre d3ae4b808c Remove default port 5432 in generic function 2019-11-12 13:27:42 +01:00
Rafa de la Torre 26f91001ee Retrieve port from the catalog 2019-11-12 13:06:14 +01:00
Rafa de la Torre 43b242e610 Retrieve host from the catalog 2019-11-12 13:02:04 +01:00