Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Redirect Postgres server logs to a file #873

Closed
ndeodhar opened this issue Feb 15, 2019 · 0 comments
Closed

Redirect Postgres server logs to a file #873

ndeodhar opened this issue Feb 15, 2019 · 0 comments
Assignees
Labels
kind/enhancement This is an enhancement of an existing feature

Comments

@ndeodhar
Copy link
Contributor

Currently postgres server logs are not stored in any dir. We should change that to direct the logs to a file.

@ndeodhar ndeodhar added the kind/enhancement This is an enhancement of an existing feature label Feb 15, 2019
@ndeodhar ndeodhar self-assigned this Feb 15, 2019
yugabyte-ci pushed a commit that referenced this issue Feb 21, 2019
Summary:
Currently, postgres server logs are not saved anywhere and simply written to stderr. This change saves the logs in tserver/logs directory.
Logging_collector will use rolling logs for postgres.

Test Plan: Started postgres server and verified that logs are being written to tserver/logs/postgresql-%Y-%m-%d_%H%M%S.log

Reviewers: mihnea, amitanand, mikhail

Reviewed By: mikhail

Subscribers: kannan, yql, ybase

Differential Revision: https://phabricator.dev.yugabyte.com/D6183
yugabyte-ci pushed a commit that referenced this issue Feb 22, 2019
Summary: https://phabricator.dev.yugabyte.com/D6183 fails Jenkins tests. Reverting this change.

Test Plan:
Tests succeed:
mvn test -Dtest=org.yb.pgsql.TestPgDelete
mvn test

Reviewers: mihnea

Reviewed By: mihnea

Differential Revision: https://phabricator.dev.yugabyte.com/D6214
yugabyte-ci pushed a commit that referenced this issue Feb 25, 2019
Summary:
Similar to reverted version: https://phabricator.dev.yugabyte.com/D6183
The original diff failed tests on Jenkins because tests use --logtostderr flag. This diff accounts for that flag.

Test Plan:
Tests pass now.
```
mvn test -Dtest=org.yb.pgsql.TestPgDelete

[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary for YugaByte 0.8.0-SNAPSHOT:
[INFO]
[INFO] YugaByte ........................................... SUCCESS [  0.411 s]
[INFO] YB Annotations ..................................... SUCCESS [  0.462 s]
[INFO] YB Java Client ..................................... SUCCESS [  0.737 s]
[INFO] YB commandline interface ........................... SUCCESS [  0.104 s]
[INFO] YB CQL Support ..................................... SUCCESS [  0.127 s]
[INFO] YB PostgreSQL Support .............................. SUCCESS [02:42 min]
[INFO] YB Load Tester ..................................... SUCCESS [  0.511 s]
[INFO] YB Jedis Tests ..................................... SUCCESS [  0.117 s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  02:45 min
[INFO] Finished at: 2019-02-22T14:55:11-08:00
[INFO] ------------------------------------------------------------------------
```

After setting up cluster using yb-ctl, ensured that postgres logs are present in tserver/logs.

Reviewers: mikhail, mihnea, kannan

Reviewed By: kannan

Subscribers: kannan, ybase

Differential Revision: https://phabricator.dev.yugabyte.com/D6226
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/enhancement This is an enhancement of an existing feature
Projects
None yet
Development

No branches or pull requests

1 participant