You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: src/connections/storage/catalog/postgres/index.md
+6-5Lines changed: 6 additions & 5 deletions
Original file line number
Diff line number
Diff line change
@@ -4,7 +4,7 @@ rewite: true
4
4
redirect_from:
5
5
- '/connections/warehouses/catalog/postgres/'
6
6
---
7
-
PostgreSQL, or Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.
7
+
PostgreSQL, or Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.
8
8
9
9
PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable views and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability. Developed by the PostgreSQL Global Development Group, free and open-source.
10
10
@@ -45,7 +45,7 @@ This guide explains how to set up a Postgres database with Heroku. Heroku is a c
45
45
46
46
When you click **Create Database**, a modal appears with your plan choices. Depending on your needs, some plans may be more suitable than others - for example, more expensive plans generally have better performance and more storage. Segment recommends that new customers start with the "Standard 4" plan.
47
47
48
-
For the fastest sync times, choose the US East region.
48
+
For the fastest sync times, choose the US East region.
49
49
50
50
After you configure these settings, click "Login to Install" and/or "Visit Heroku Dashboard to create your first app".
51
51
@@ -354,10 +354,11 @@ GRANT CREATE, TEMPORARY ON DATABASE <enter database name here> TO segment;
354
354
355
355
356
356
## Security
357
-
Make sure you're logging in with a user that has read and write permissions so that we can write to your database.
358
-
359
-
- Whitelist the Segment IP (`52.25.130.38/32`)
357
+
To make sure your Postgres database is secure:
358
+
- Log in with a user that has read and write permissions so that Segment can write to your database.
359
+
- Whitelist the Segment IP (`52.25.130.38/32`). Otherwise, Segment won't be able to load your data.
360
360
- Create a service user that has `read/write` permissions.
361
+
- Always require SSL and make sure your data warehouse can only accept secure connections. Segment only connects to your data warehouse using SSL.
Copy file name to clipboardExpand all lines: src/connections/storage/catalog/redshift/index.md
+5Lines changed: 5 additions & 0 deletions
Original file line number
Diff line number
Diff line change
@@ -65,8 +65,13 @@ After creating a Redshift warehouse, the next step is to connect Segment:
65
65
4. Select which sources and collections/properties will sync to this Warehouse
66
66
67
67
## Security
68
+
69
+
### VPC
68
70
VPCs keep servers inaccessible to traffic from the internet. With VPC, you're able to designate specific web servers access to your servers. In this case, you will be whitelisting the [Segment IPs](/docs/connections/storage/warehouses/faq#which-ips-should-i-whitelist) to write to your data warehouse.
69
71
72
+
### SSL
73
+
Always require SSL and make sure your data warehouse can only accept secure connections. Segment only connects to your data warehouse using SSL.
0 commit comments