lmrc-postgres 0.3.16

PostgreSQL management library for the LMRC Stack - comprehensive library for managing PostgreSQL installations on remote servers via SSH
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

//! Basic PostgreSQL installation example
//!
//! This example demonstrates the simplest way to install and configure PostgreSQL
//! on a remote server.
//!
//! Usage:
//! ```bash
//! cargo run --example basic_install
//! ```

use lmrc_postgres::{PostgresConfig, PostgresManager};

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    // Initialize logging
    tracing_subscriber::fmt::init();

    // Build PostgreSQL configuration
    let config = PostgresConfig::builder()
        .version("15")
        .database_name("myapp")
        .username("myuser")
        .password("secure_password_123")
        .build()?;

    // Create manager
    // NOTE: Update these values for your environment
    let manager = PostgresManager::builder()
        .config(config)
        .server_ip("192.168.1.100") // Change to your server IP
        .ssh_user("root") // Change to your SSH user
        .ssh_password("your_ssh_password") // Or use .ssh_key_path()
        .build()?;

    println!("Starting PostgreSQL installation...");

    // Install and configure PostgreSQL (idempotent)
    manager.setup().await?;

    println!("PostgreSQL installed and configured successfully!");

    // Test the connection
    println!("Testing database connection...");
    manager.test_connection().await?;

    println!("✓ Connection test successful!");
    println!("PostgreSQL is ready to use!");

    Ok(())
}