Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
4
Newest
 Student
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Feb
20
revised Why won't pg_basebackup output go to log?
modified question due to feedback.
Feb
20
comment Can SQL Server stop me from running an UPDATE statement without a WHERE clause?
You don't write the commit, or if you do, you wrap it in an IF that checks some condition (@@rowcount, @@error are good ones to check).
Feb
10
answered Can SQL Server stop me from running an UPDATE statement without a WHERE clause?
Jan
27
comment Update a set of SQL statements
What data types are the @constVal, FuncWeight column, and PercentMatch from your func?
Jan
27
comment Update a set of SQL statements
In terms of column names, I followed what you showed in your question. If the temp table has a column named PercentMatch, then the values are transposed.
Jan
26
answered Update a set of SQL statements
Jan
23
awarded  Student
Jan
22
comment Why won't pg_basebackup output go to log?
Yes, I suppose you're right about the path. Other crons under pg user have no problem with ts, though, so I don't think that's it. And pg_basebackup runs, so that's not it either. I don't think it's a path problem.
Jan
22
comment Why won't pg_basebackup output go to log?
Oh, if I run echo '' | ts '%F %T %Z' as the postgres user I see the timestamp, so ts seems to be reachable by that user.
Jan
22
comment Why won't pg_basebackup output go to log?
The only thing in the cron log is a single entry showing that the script is called. The cron is under the postgres user, which darn sure better have access to pg_basebackup. But again, the backup runs, it just doesn't work. I need to see the output to find out why.
Jan
22
comment Why won't pg_basebackup output go to log?
I'll give that a try, but I'm a bit confused why that would affect the log output. The pg_basebackup does execute as seen by the (invalid) backup file that's created.
Jan
22
comment How to view the query of another session in pg_stat_activity without being super user?
Thanks! Was just trying to figure out how to give a monitor account permission to read from pg_stat_activity without granting SUPERUSER.
Jan
20
comment Which parameters was a stored procedure or command executed with?
If you always want to capture parameters for a specific stored proc, Extended Events are probably the lowest impact solution. A little more a of a learning curve than profiler, though ;)
Jan
20
revised Migrate small sets of data from production to staging/sandbox
expanded option 1, fixed typo
Jan
20
answered Migrate small sets of data from production to staging/sandbox
Jan
20
asked Why won't pg_basebackup output go to log?
Oct
2
awarded  Supporter
Oct
2
awarded  Teacher
Oct
2
awarded  Editor
Oct
2
revised Lookup table for a one-to-many relationship
Added Postgres syntax