Skip to content

Commit 02aafd2

Browse files
committed
warehouses require SSL
[netlify-build]
1 parent 805df55 commit 02aafd2

File tree

3 files changed

+16
-7
lines changed

3 files changed

+16
-7
lines changed

src/connections/storage/catalog/db2/index.md

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -87,10 +87,13 @@ database shortly.
8787
If your Db2 Warehouse is in a private network, be sure to [whitelist
8888
Segment's IP
8989
address](https://segment.com/docs/connections/storage/warehouses/faq/#which-ips-should-i-whitelist).
90-
Otherwise, we will not be able to load your data.
90+
Otherwise, Segment won't be able to load your data.
9191

9292
### Unique User
9393

94-
We strongly recommend creating a unique User for the Segment Db2 Warehouse
94+
Segment recommends you to create a unique User for the Segment Db2 Warehouse
9595
connection to your Db2 Warehouse instance so that you can manage permissions
9696
separately.
97+
98+
### SSL
99+
Always require SSL and make sure your data warehouse can only accept secure connections. Segment only connects to your data warehouse using SSL.

src/connections/storage/catalog/postgres/index.md

Lines changed: 6 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ rewite: true
44
redirect_from:
55
- '/connections/warehouses/catalog/postgres/'
66
---
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.
88

99
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.
1010

@@ -45,7 +45,7 @@ This guide explains how to set up a Postgres database with Heroku. Heroku is a c
4545

4646
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.
4747

48-
For the fastest sync times, choose the US East region.
48+
For the fastest sync times, choose the US East region.
4949

5050
After you configure these settings, click "Login to Install" and/or "Visit Heroku Dashboard to create your first app".
5151

@@ -354,10 +354,11 @@ GRANT CREATE, TEMPORARY ON DATABASE <enter database name here> TO segment;
354354

355355

356356
## 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.
360360
- 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.
361362
362363
## Best Practices
363364

src/connections/storage/catalog/redshift/index.md

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -65,8 +65,13 @@ After creating a Redshift warehouse, the next step is to connect Segment:
6565
4. Select which sources and collections/properties will sync to this Warehouse
6666

6767
## Security
68+
69+
### VPC
6870
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.
6971

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.
74+
7075
## Best practices
7176

7277
### Networking

0 commit comments

Comments
 (0)