Setting up PostgreSQL on a PC


72
views
0
3 months ago by
How does one install Postgres and whatever software is commonly associated with it at Zimmer Biomet?
Community: Zimmer Biomet

1 Answer


1
3 months ago by
Legacy Biomet
1.    Call your Biomet Helpdesk as they need to install the software.  You will need to follow the below instructions.
2.    Click this link
a.    \\sbcsdkprd01.zmr.zimmer.com\FieldApplications\Postgres\
3.    Run pgadmin3.msi and accept all defaults
4.    Launch PgAdminIII (aka the elephant)
5.    Click  button to create a new connection
6.    Input the following Information
a.    Name: vsbslgprd01
b.    Host: vsbslgprd01.zmr.zimmer.com
c.     Port: 5432
d.    Username: reader
e.    Password: zimmer (all lowercase)


Also, you will need to install the ODBC Driver:
7.  \\sbcsdkprd01.zmr.zimmer.com\FieldApplications\Postgres\ (psqlodbc_x86.msi)
8.   Go to your  control panel || administrative tools
9.   double click Data Sources (ODBC 32 bit)
10.Click Add
11.Select "PostgreSQL Unicode"
12.Enter the following Info:
a.   Data Source: coginst1
b.   Database: postgres
c.    server: vsbslgprd01.zmr.zimmer.com
d.   User Name: reader
e.   password: zimmer
f.     Description: coginst1
g.    Click save

13.Click Add
14.then select "PostgreSQL ANSI"
15.Enter the following Info:
a.   Data Source: vsbslgprd01
b.   Database: postgres
c.    server: vsbslgprd01.zmr.zimmer.com
d.   userName: reader
e.   password: zimmer
f.     Description: vsbslgprd01
16. Click Save

Note:  The 32-bit ODBC is buried on many legacy-B machines.  To access the program directly, install via:

C:\Windows\SysWOW64\odbcad32.exe

64-bit ODBC will not work on 32-bit Office installations.

Legacy Zimmer
Install PgAdmin from here:
1.    \\sbcsdkprd01.zmr.zimmer.com\FieldApplications\Postgres\
2.   Run pgadmin3.msi, accept all defaults
3.   Launch PgAdminIII (aka the elephant)
4.   Click the  button to create a new connection
5.   Input the following information:
Name: vsbslgprd01
Host: vsbslgprd01.zmr.zimmer.com
Port: 5432
Username: reader
Password: zimmer (all lowercase)

6.   Install the OBDC Driver from Here: \\sbcsdkprd01.zmr.zimmer.com\FieldApplications\Postgres\ (psqlodbc_x86.msi)
7.   Go to your  control panel || administrative tools
8.   double click Data Sources (ODBC 32 bit)
9.   Click Add
10.Select "PostgreSQL Unicode"
11.Enter the following Info:
a.   Data Source: coginst1
b.   Database: postgres
c.    server: vsbslgprd01.zmr.zimmer.com
d.   User Name: reader
e.   password: zimmer
f.     Description: coginst1
g.    Click save

12.Click Add
13.then select "PostgreSQL ANSI"
14.Enter the following Info:
a.   Data Source: vsbslgprd01
b.   Database: postgres
c.    server: vsbslgprd01.zmr.zimmer.com
d.   userName: reader
e.   password: zimmer
f.     Description: vsbslgprd01

Install the Zimmer Ribbon for Excel if not already present: \\sbcsdkprd01.zmr.zimmer.com\FieldApplications\VSTO\
Please login to add an answer/comment or follow this question.

Similar posts:
Search »
  • Nothing matches yet.