A simple question: Why 'pg_ctl: command not found...' ?
Hello everyone, When I start to learn the 'pg_ctl', the bash echo 'pg_ctl: command not found...' and then print 'Install package 'postgresql-server' to provide command 'pg_ctl'? [N/y]' I am confused because I had already install the PostgreSQL correctly just follow the postgres Document,to prove that,I use the psql to connect to the postgres and execute some sql statements (Just like 'CREATE TABLE', 'SELECT' and 'INSERT'),and these statements executed successfully. So how to solve this problem? Should I use the dnf to install the 'postgresql-server' or just add some path to the environment variable? My system is Fedora 35 and the PostgreSQL version is 14. Thanks in advance!
Where is the best place to read for the paper around database?
Hello everyone, I am a student who are interest in database,can anyone recommend a website where can read and download the papers around database? Thanks in advance! Best wishes, Wen Yi.
Why password authentication failed for user "postgres"?
Hello everyone, I am a newbie to the postgres,when I use the psql to connect to the postgres,a error message printed: These command list like this: psql -U postgres Password for user postgres:postgres *postgreSQL: password authentication failed for user "postgres"* * * How to solve this problem? Thanks in advance!
[Beginner Querstion]Where can I find the news of database?
Hello everyone, I am a student come from the University of Emergency Management and I am learning the postgres. As you can see,I want to get some latest news,opinions of the database,but I don't know where I can get them. (I have already subscribe the rss of planet postgresql,but I want to seek more) Thanks in advance! Yours, BeginnerC.
[BeginnerQuestion]Why these is 6 rows in my SELECT statement?
Hello community, I am checking my pg_stat_activity view,but something confused me. Just like this: postgres=# SELECT wait_event_type, wait_event FROM pg_stat_activity; wait_event_type | wait_event -+- Activity| AutoVacuumMain Activity| LogicalLauncherMain | Activity| BgWriterHibernate Activity| CheckpointerMain Activity| WalWriterMain (6 rows) As you can see, the third row is empty,but I don't know why. Can anyone provide some solution to me? Thanks in advance! Yours, BeginnerC.
