Controller:
public function actionIndex(){
$query = Post::find()->select('id, title, excerpt, category_id')->with('category')->orderBy('id DESC');
$pages = new \yii\data\Pagination(['totalCount' => $query->count(), 'pageSize' => 2, 'pageSizeParam' => false, 'forcePageParam' => false]);
$posts = $query->offset($pages->offset)->limit($pages->limit)->all();
$this->setMeta('Yii2', 'ключевики', 'Описание сайта');
return $this->render('index', compact('posts','pages'));
View:
<?=\yii\widgets\LinkPager::widget(['pagination'=>$pages]) ?>